- Timestamp:
- 2007/07/20 15:58:59 (17 years ago)
- Location:
- branches/feature-module-update
- Files:
-
- 1 edited
- 2 copied
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update
-
Property
svn:ignore
set to
.cache
.settings
.projectOptions
-
Property
svn:ignore
set to
-
branches/feature-module-update/html/admin/mail/inc_mailmagazine.php
r12157 r15078 5 5 * http://www.lockon.co.jp/ 6 6 * 7 * CSV ÇÛ¿®µ¡Ç½¼ÂÁõ¤Î¤¿¤á¡¢¶¦ÄÌÉôʬ¤ò³°Éô¥Õ¥¡¥¤¥ë²½¤·¤Þ¤·¤¿¡£<br>7 * CSV配信機能実装のため、共通部分を外部ファイル化しました。<br> 8 8 * @author hirokazu_fukuda 9 9 * @version 2005/12/27 … … 11 11 12 12 13 //---- ¸¡º÷ÍѹàÌÜÇÛÎó14 $objPage->arrHtmlmail = array( "" => " ξÊý", 1 => "HTML", 2 => "TEXT" );15 16 17 //---- ÇÛÎóÆâÍÆÀìÍѹàÌܤÎÇÛÎó13 //---- 検索用項目配列 14 $objPage->arrHtmlmail = array( "" => "両方", 1 => "HTML", 2 => "TEXT" ); 15 16 17 //---- 配列内容専用項目の配列 18 18 $arrRegistColumn = array( 19 19 array( "column" => "template_id", "convert" => "n" ) … … 28 28 ); 29 29 30 //---- ¥á¥ë¥Þ¥¬²ñ°÷¼ïÊÌ30 //---- メルマガ会員種別 31 31 $arrCustomerType = array( 32 1 => " ²ñ°÷",33 2 => " Èó²ñ°÷",34 //3 => "CSV ÅÐÏ¿"32 1 => "会員", 33 2 => "非会員", 34 //3 => "CSV登録" 35 35 ); 36 36 37 //---- ¸¡º÷¹àÌÜ37 //---- 検索項目 38 38 $arrSearchColumn = array( 39 39 array( "column" => "name", "convert" => "aKV"), … … 82 82 //-------------------------------------------------------------------------------------------------------------------------------------- 83 83 84 //---- HTML ¥Æ¥ó¥×¥ì¡¼¥È¤ò»ÈÍѤ¹¤ë¾ì¹ç¡¢¥Ç¡¼¥¿¤ò¼èÆÀ¤¹¤ë¡£84 //---- HTMLテンプレートを使用する場合、データを取得する。 85 85 function lfGetHtmlTemplateData($id) { 86 86 … … 90 90 $list_data = $result[0]; 91 91 92 // ¥á¥¤¥ó¾¦ÉʤξðÊó¼èÆÀ92 // メイン商品の情報取得 93 93 $sql = "SELECT name, main_image, point_rate, deliv_fee, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?"; 94 94 $main = $conn->getAll($sql, array($list_data["main_product_id"])); 95 95 $list_data["main"] = $main[0]; 96 96 97 // ¥µ¥Ö¾¦ÉʤξðÊó¼èÆÀ97 // サブ商品の情報取得 98 98 $sql = "SELECT product_id, name, main_list_image, price01_min, price01_max, price02_min, price02_max FROM vw_products_allclass AS allcls WHERE product_id = ?"; 99 99 $k = 0; … … 113 113 $result = $conn->getAll($sql, array($list_data["sub_product_id" .$j])); 114 114 $list_data["sub"][$k][$l] = $result[0]; 115 $list_data["sub"][$k]["data_exists"] = "OK"; // Åö³ºÃʤ˥ǡ¼¥¿¤¬£±¤Ä°Ê¾å¸ºß¤¹¤ë¥Õ¥é¥°115 $list_data["sub"][$k]["data_exists"] = "OK"; //当該段にデータが1つ以上存在するフラグ 116 116 } 117 117 $l ++; … … 120 120 } 121 121 122 //--- ¥Æ¥ó¥×¥ì¡¼¥È¤Î¼ïÎà¤òÊÖ¤¹122 //--- テンプレートの種類を返す 123 123 function lfGetTemplateMethod($conn, $templata_id){ 124 124 … … 128 128 } 129 129 130 //--- hidden Í×ÁǽÐÎÏÍÑÇÛÎó¤ÎºîÀ®130 //--- hidden要素出力用配列の作成 131 131 function lfGetHidden( $array ){ 132 132 if ( is_array($array) ){ … … 144 144 } 145 145 146 //---- ¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹146 //---- 取得文字列の変換 147 147 function lfConvertParam($array, $arrSearchColumn) { 148 148 149 // ʸ»úÊÑ´¹149 // 文字変換 150 150 foreach ($arrSearchColumn as $data) { 151 151 $arrConvList[ $data["column"] ] = $data["convert"]; … … 154 154 $new_array = array(); 155 155 foreach ($arrConvList as $key => $val) { 156 if ( strlen($array[$key]) > 0 ){ // ¥Ç¡¼¥¿¤Î¤¢¤ë¤â¤Î¤À¤±ÊÖ¤¹156 if ( strlen($array[$key]) > 0 ){ // データのあるものだけ返す 157 157 $new_array[$key] = $array[$key]; 158 158 if( strlen($val) > 0) { … … 166 166 167 167 168 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯168 //---- 入力エラーチェック 169 169 function lfErrorCheck($array, $flag = '') { 170 170 171 // flag ¤ÏÅÐÏ¿»þÍÑ171 // flag は登録時用 172 172 173 173 $objErr = new SC_CheckError($array); 174 174 175 $objErr->doFunc(array(" ¸ÜµÒ¥³¡¼¥É", "customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));176 $objErr->doFunc(array(" ÅÔÆ»Éܸ©", "pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));177 $objErr->doFunc(array(" ¸ÜµÒ̾", "name", STEXT_LEN), array("MAX_LENGTH_CHECK"));178 $objErr->doFunc(array(" ¸ÜµÒ̾(¥«¥Ê)", "kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK"));179 180 $objErr->doFunc(array(' ¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));181 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));182 183 $objErr->doFunc(array(" ¹ØÆþ²ó¿ô(³«»Ï)", "buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));184 $objErr->doFunc(array(" ¹ØÆþ²ó¿ô(½ªÎ»)", "buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));185 if ((is_numeric($array["buy_total_from"]) && is_numeric($array["buy_total_to"]) ) && ($array["buy_times_from"] > $array["buy_times_to"]) ) $objErr->arrErr["buy_times_from"] .= " ¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";186 187 $objErr->doFunc(array(" ÃÂÀ¸·î", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));188 189 $objErr->doFunc(array(" ÃÂÀ¸Æü(³«»ÏÆü)", "b_start_year", "b_start_month", "b_start_day",), array("CHECK_DATE"));190 $objErr->doFunc(array(" ÃÂÀ¸Æü(½ªÎ»Æü)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE"));191 $objErr->doFunc(array(" ÃÂÀ¸Æü(³«»ÏÆü)","ÃÂÀ¸Æü(½ªÎ»Æü)", "b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM"));192 193 $objErr->doFunc(array(" ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "start_year", "start_month", "start_day",), array("CHECK_DATE"));194 $objErr->doFunc(array(" ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "end_year", "end_month", "end_day"), array("CHECK_DATE"));195 $objErr->doFunc(array(" ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM"));196 197 $objErr->doFunc(array(" ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE"));198 $objErr->doFunc(array(" ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE"));199 $objErr->doFunc(array(" ºÇ½ª¹ØÆþÆü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM"));200 201 $objErr->doFunc(array(" ¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK"));202 203 $objErr->doFunc(array(" ¹ØÆþ¾¦ÉÊ̾", "buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));204 205 $objErr->doFunc(array(" ¹ØÆþ¶â³Û(³«»Ï)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));206 $objErr->doFunc(array(" ¹ØÆþ¶â³Û(½ªÎ»)", "buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));207 208 $objErr->doFunc(array(" ¥¥ã¥ó¥Ú¡¼¥ó", "campaign_id", INT_LEN), array("NUM_CHECK"));209 210 // ¹ØÆþ¶â³Û(from) ¡ä ¹ØÆþ¶â³Û(to) ¤Î¾ì¹ç¤Ï¥¨¥é¡¼¤È¤¹¤ë175 $objErr->doFunc(array("顧客コード", "customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 176 $objErr->doFunc(array("都道府県", "pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK")); 177 $objErr->doFunc(array("顧客名", "name", STEXT_LEN), array("MAX_LENGTH_CHECK")); 178 $objErr->doFunc(array("顧客名(カナ)", "kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK")); 179 180 $objErr->doFunc(array('メールアドレス', "email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 181 $objErr->doFunc(array("電話番号", "tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 182 183 $objErr->doFunc(array("購入回数(開始)", "buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 184 $objErr->doFunc(array("購入回数(終了)", "buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 185 if ((is_numeric($array["buy_total_from"]) && is_numeric($array["buy_total_to"]) ) && ($array["buy_times_from"] > $array["buy_times_to"]) ) $objErr->arrErr["buy_times_from"] .= "※ 購入回数の指定範囲が不正です。"; 186 187 $objErr->doFunc(array("誕生月", "birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK")); 188 189 $objErr->doFunc(array("誕生日(開始日)", "b_start_year", "b_start_month", "b_start_day",), array("CHECK_DATE")); 190 $objErr->doFunc(array("誕生日(終了日)", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE")); 191 $objErr->doFunc(array("誕生日(開始日)","誕生日(終了日)", "b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM")); 192 193 $objErr->doFunc(array("登録・更新日(開始日)", "start_year", "start_month", "start_day",), array("CHECK_DATE")); 194 $objErr->doFunc(array("登録・更新日(終了日)", "end_year", "end_month", "end_day"), array("CHECK_DATE")); 195 $objErr->doFunc(array("登録・更新日(開始日)","登録・更新日(終了日)", "start_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM")); 196 197 $objErr->doFunc(array("最終購入日(開始日)", "buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE")); 198 $objErr->doFunc(array("最終購入(終了日)", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE")); 199 $objErr->doFunc(array("最終購入日(開始日)","登録・更新日(終了日)", "buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM")); 200 201 $objErr->doFunc(array("購入商品コード", "buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK")); 202 203 $objErr->doFunc(array("購入商品名", "buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK")); 204 205 $objErr->doFunc(array("購入金額(開始)", "buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 206 $objErr->doFunc(array("購入金額(終了)", "buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK")); 207 208 $objErr->doFunc(array("キャンペーン", "campaign_id", INT_LEN), array("NUM_CHECK")); 209 210 //購入金額(from) > 購入金額(to) の場合はエラーとする 211 211 if ( (is_numeric($array["buy_total_from"]) && is_numeric($array["buy_total_to"]) ) && 212 212 ($array["buy_total_from"] > $array["buy_total_to"]) ) { 213 $objErr->arrErr["buy_total_from"] .= " ¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";213 $objErr->arrErr["buy_total_from"] .= "※ 購入金額の指定範囲が不正です。"; 214 214 } 215 215 216 216 if ( $flag ){ 217 $objErr->doFunc(array(" ¥Æ¥ó¥×¥ì¡¼¥È", "template_id"), array("EXIST_CHECK", "NUM_CHECK"));218 $objErr->doFunc(array(" ¥á¡¼¥ëÁ÷¿®Ë¡Ë¡", "mail_method"), array("EXIST_CHECK", "NUM_CHECK"));217 $objErr->doFunc(array("テンプレート", "template_id"), array("EXIST_CHECK", "NUM_CHECK")); 218 $objErr->doFunc(array("メール送信法法", "mail_method"), array("EXIST_CHECK", "NUM_CHECK")); 219 219 220 220 if(MELMAGA_BATCH_MODE) { 221 $objErr->doFunc(array(" ÇÛ¿®Æü¡Êǯ¡Ë","send_year"), array("EXIST_CHECK", "NUM_CHECK"));222 $objErr->doFunc(array(" ÇÛ¿®Æü¡Ê·î¡Ë","send_month"), array("EXIST_CHECK", "NUM_CHECK"));223 $objErr->doFunc(array(" ÇÛ¿®Æü¡ÊÆü¡Ë","send_day"), array("EXIST_CHECK", "NUM_CHECK"));224 $objErr->doFunc(array(" ÇÛ¿®Æü¡Ê»þ¡Ë","send_hour"), array("EXIST_CHECK", "NUM_CHECK"));225 $objErr->doFunc(array(" ÇÛ¿®Æü¡Êʬ¡Ë","send_minutes"), array("EXIST_CHECK", "NUM_CHECK"));226 $objErr->doFunc(array(" ÇÛ¿®Æü", "send_year", "send_month", "send_day"), array("CHECK_DATE"));227 $objErr->doFunc(array(" ÇÛ¿®Æü", "send_year", "send_month", "send_day","send_hour", "send_minutes"), array("ALL_EXIST_CHECK"));221 $objErr->doFunc(array("配信日(年)","send_year"), array("EXIST_CHECK", "NUM_CHECK")); 222 $objErr->doFunc(array("配信日(月)","send_month"), array("EXIST_CHECK", "NUM_CHECK")); 223 $objErr->doFunc(array("配信日(日)","send_day"), array("EXIST_CHECK", "NUM_CHECK")); 224 $objErr->doFunc(array("配信日(時)","send_hour"), array("EXIST_CHECK", "NUM_CHECK")); 225 $objErr->doFunc(array("配信日(分)","send_minutes"), array("EXIST_CHECK", "NUM_CHECK")); 226 $objErr->doFunc(array("配信日", "send_year", "send_month", "send_day"), array("CHECK_DATE")); 227 $objErr->doFunc(array("配信日", "send_year", "send_month", "send_day","send_hour", "send_minutes"), array("ALL_EXIST_CHECK")); 228 228 } 229 229 $objErr->doFunc(array("Subject", "subject", STEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); 230 $objErr->doFunc(array(" ËÜʸ", 'body', LLTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); // HTML¥Æ¥ó¥×¥ì¡¼¥È¤ò»ÈÍѤ·¤Ê¤¤¾ì¹ç230 $objErr->doFunc(array("本文", 'body', LLTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK")); // HTMLテンプレートを使用しない場合 231 231 } 232 232 … … 234 234 } 235 235 236 /* ¥Æ¥ó¥×¥ì¡¼¥ÈID¤Èsubject¤ÎÇÛÎó¤òÊÖ¤¹*/236 /* テンプレートIDとsubjectの配列を返す */ 237 237 function getTemplateList($conn){ 238 238 global $arrMagazineTypeAll; … … 240 240 $sql = "SELECT template_id, subject, mail_method FROM dtb_mailmaga_template WHERE del_flg = 0 "; 241 241 if ($_POST["htmlmail"] == 2 || $_POST['mail_type'] == 2) { 242 $sql .= " AND mail_method = 2 "; //TEXT ´õ˾¼Ô¤Ø¤ÎTEST¥á¡¼¥ë¥Æ¥ó¥×¥ì¡¼¥È¥ê¥¹¥È242 $sql .= " AND mail_method = 2 "; //TEXT希望者へのTESTメールテンプレートリスト 243 243 } 244 244 $sql .= " ORDER BY template_id DESC"; … … 247 247 if ( is_array($result) ){ 248 248 foreach( $result as $line ){ 249 $return[$line['template_id']] = " ¡Ú" . $arrMagazineTypeAll[$line['mail_method']] . "¡Û" . $line['subject'];249 $return[$line['template_id']] = "【" . $arrMagazineTypeAll[$line['mail_method']] . "】" . $line['subject']; 250 250 } 251 251 } … … 254 254 } 255 255 256 /* ¥Æ¥ó¥×¥ì¡¼¥ÈID¤«¤é¥Æ¥ó¥×¥ì¡¼¥È¥Ç¡¼¥¿¤ò¼èÆÀ*/256 /* テンプレートIDからテンプレートデータを取得 */ 257 257 function getTemplateData($conn, $id){ 258 258
Note: See TracChangeset
for help on using the changeset viewer.