Changeset 14321
- Timestamp:
- 2007/06/05 21:17:57 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/admin/mail/index.php
r14318 r14321 9 9 10 10 class LC_Page { 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 global $arrSex; 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 11 var $arrSession; 12 var $arrHtmlmail; 13 var $arrNowDate; 14 function LC_Page() { 15 $this->tpl_mainpage = 'mail/index.tpl'; 16 $this->tpl_mainno = 'mail'; 17 $this->tpl_subnavi = 'mail/subnavi.tpl'; 18 $this->tpl_subno = "index"; 19 $this->tpl_pager = DATA_PATH . 'Smarty/templates/admin/pager.tpl'; 20 $this->tpl_subtitle = 'ÇÛ¿®ÆâÍÆÀßÄê'; 21 22 global $arrPref; 23 $this->arrPref = $arrPref; 24 global $arrJob; 25 $arrJob["ÉÔÌÀ"] = "ÉÔÌÀ"; 26 $this->arrJob = $arrJob; 27 global $arrSex; 28 $this->arrSex = $arrSex; 29 global $arrMailType; 30 $this->arrMailType = $arrMailType; 31 global $arrDomain; 32 $this->arrDomain = $arrDomain; 33 global $arrPageRows; 34 $this->arrPageRows = $arrPageRows; 35 // ¥Ú¡¼¥¸¥Ê¥ÓÍÑ 36 $this->tpl_pageno = $_POST['search_pageno']; 37 global $arrMAILMAGATYPE; 38 $this->arrMAILMAGATYPE = $arrMAILMAGATYPE; 39 $this->arrHtmlmail[''] = "¤¹¤Ù¤Æ"; 40 $this->arrHtmlmail[1] = $arrMAILMAGATYPE[1]; 41 $this->arrHtmlmail[2] = $arrMAILMAGATYPE[2]; 42 global $arrCustomerType; 43 $this->arrCustomerType = $arrCustomerType; 44 global $arrDOMAIN; 45 $this->arrDomain = $arrDOMAIN; 46 $this->arrDomain[''] = "»ØÄꤷ¤Ê¤¤"; 47 $this->arrDomain[1] = $arrDOMAIN[1]; 48 $this->arrDomain[2] = $arrDOMAIN[2]; 49 } 50 50 } 51 51 52 52 class LC_HTMLtemplate { 53 53 var $list_data; 54 54 } 55 55 … … 69 69 70 70 /* 71 71 query:ÇÛ¿®ÍúÎò¡Ö³Îǧ¡× 72 72 */ 73 73 if ($_GET["mode"] == "query" && sfCheckNumLength($_GET["send_id"])) { 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 74 // Á÷¿®ÍúÎò¤è¤ê¡¢Á÷¿®¾ò·ï³Îǧ²èÌÌ 75 $sql = "SELECT search_data FROM dtb_send_history WHERE send_id = ?"; 76 $result = $conn->getOne($sql, array($_GET["send_id"])); 77 $tpl_path = "mail/query.tpl"; 78 79 $list_data = unserialize($result); 80 81 // ÅÔÆ»Éܸ©¤òÊÑ´¹ 82 $list_data['pref_disp'] = $objPage->arrPref[$list_data['pref']]; 83 84 //¥É¥á¥¤¥ó»ØÄê¤òÊÑ´¹ 85 $list_data['domain_disp'] = $objPage->arrDomain[$list_data['domain']]; 86 87 // ÇÛ¿®·Á¼° 88 $list_data['htmlmail_disp'] = $objPage->arrHtmlmail[$list_data['htmlmail']]; 89 90 // ÀÊ̤ÎÊÑ´¹ 91 if (count($list_data['sex']) > 0) { 92 foreach($list_data['sex'] as $key => $val){ 93 $list_data['sex'][$key] = $objPage->arrSex[$val]; 94 $sex_disp .= $list_data['sex'][$key] . " "; 95 } 96 $list_data['sex_disp'] = $sex_disp; 97 } 98 99 // ¿¦¶È¤ÎÊÑ´¹ 100 if (count($list_data['job']) > 0) { 101 foreach($list_data['job'] as $key => $val){ 102 $list_data['job'][$key] = $objPage->arrJob[$val]; 103 $job_disp .= $list_data['job'][$key] . " "; 104 } 105 $list_data['job_disp'] = $job_disp; 106 } 107 108 // ¥«¥Æ¥´¥êÊÑ´¹ 109 $arrCatList = sfGetCategoryList(); 110 $list_data['category_name'] = $arrCatList[$list_data['category_id']]; 111 112 $objPage->list_data = $list_data; 113 114 $objView->assignobj($objPage); 115 $objView->display($tpl_path); 116 exit; 117 117 } 118 118 … … 122 122 switch($_POST['mode']) { 123 123 /* 124 125 124 search:¡Ö¸¡º÷¡×¥Ü¥¿¥ó 125 back:¸¡º÷·ë²Ì²èÌÌ¡ÖÌá¤ë¡×¥Ü¥¿¥ó 126 126 */ 127 127 case 'delete': 128 128 case 'search': 129 129 case 'back': 130 131 132 133 134 135 136 137 138 139 140 141 142 //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ 143 144 // À¸À®¤µ¤ì¤¿WHEREʸ¤ò¼èÆÀ¤¹¤ë 145 146 147 148 149 150 151 152 153 154 155 $objPage->tpl_linemax = $linemax;// ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ156 157 158 159 $objPage->arrPagenavi = $objNavi->arrPagenavi; 160 161 162 163 164 165 166 167 // ¸¡º÷·ë²Ì¤Î¼èÆÀ 168 169 170 171 172 173 174 /* 175 130 //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È 131 $objPage->list_data = lfConvertParam($_POST, $arrSearchColumn); 132 133 //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 134 $objPage->arrErr = lfErrorCheck($objPage->list_data); 135 136 //-- ¸¡º÷³«»Ï 137 if (!is_array($objPage->arrErr)) { 138 $objPage->list_data['name'] = sfManualEscape($objPage->list_data['name']); 139 // hiddenÍ×ÁǺîÀ® 140 $objPage->arrHidden = lfGetHidden($objPage->list_data); 141 142 //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ 143 $objSelect = new SC_CustomerList($objPage->list_data, "magazine"); 144 // À¸À®¤µ¤ì¤¿WHEREʸ¤ò¼èÆÀ¤¹¤ë 145 list($where, $arrval) = $objSelect->getWhere(); 146 // ¡ÖWHERE¡×Éôʬ¤òºï½ü¤¹¤ë¡£ 147 $where = ereg_replace("^WHERE", "", $where); 148 149 // ¸¡º÷·ë²Ì¤Î¼èÆÀ 150 $objQuery = new SC_Query(); 151 $from = "dtb_customer"; 152 153 // ¹Ô¿ô¤Î¼èÆÀ 154 $linemax = $objQuery->count($from, $where, $arrval); 155 $objPage->tpl_linemax = $linemax; // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ 156 157 // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ 158 $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, SEARCH_PMAX, "fnResultPageNavi", NAVI_PMAX); 159 $objPage->arrPagenavi = $objNavi->arrPagenavi; 160 $startno = $objNavi->start_row; 161 162 // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È) 163 $objQuery->setlimitoffset(SEARCH_PMAX, $startno); 164 // ɽ¼¨½ç½ø 165 $objQuery->setorder("customer_id DESC"); 166 167 // ¸¡º÷·ë²Ì¤Î¼èÆÀ 168 $col = $objSelect->getMailMagazineColumn(lfGetIsMobile($_POST['mail_type'])); 169 $objPage->arrResults = $objQuery->select($col, $from, $where, $arrval); 170 //¸½ºß»þ¹ï¤Î¼èÆÀ 171 $objPage->arrNowDate = lfGetNowDate(); 172 } 173 break; 174 /* 175 input:¸¡º÷·ë²Ì²èÌÌ¡ÖhtmlmailÆâÍÆÀßÄê¡×¥Ü¥¿¥ó 176 176 */ 177 177 case 'input': 178 179 180 181 182 183 184 185 186 187 188 189 190 /* 191 178 //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È 179 $objPage->list_data = lfConvertParam($_POST, $arrSearchColumn); 180 //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 181 $objPage->arrErr = lfErrorCheck($objPage->list_data); 182 //-- ¥¨¥é¡¼¤Ê¤· 183 if (!is_array($objPage->arrErr)) { 184 //-- ¸½ºß»þ¹ï¤Î¼èÆÀ 185 $objPage->arrNowDate = lfGetNowDate(); 186 $objPage->arrHidden = lfGetHidden($objPage->list_data); // hiddenÍ×ÁǺîÀ® 187 $objPage->tpl_mainpage = 'mail/input.tpl'; 188 } 189 break; 190 /* 191 template:¥Æ¥ó¥×¥ì¡¼¥ÈÁªÂò 192 192 */ 193 193 case 'template': 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 $objMakeTemplate->assignobj($objTemplate); 233 234 235 236 237 /* 238 239 240 241 */ 194 //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È 195 $objPage->list_data = lfConvertParam($_POST, $arrSearchColumn); 196 197 //-- »þ¹ïÀßÄê¤Î¼èÆÀ 198 $objPage->arrNowDate['year'] = $_POST['send_year']; 199 $objPage->arrNowDate['month'] = $_POST['send_month']; 200 $objPage->arrNowDate['day'] = $_POST['send_day']; 201 $objPage->arrNowDate['hour'] = $_POST['send_hour']; 202 $objPage->arrNowDate['minutes'] = $_POST['send_minutes']; 203 204 //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 205 $objPage->arrErr = lfErrorCheck($objPage->list_data); 206 207 //-- ¸¡º÷³«»Ï 208 if ( ! is_array($objPage->arrErr)) { 209 $objPage->list_data['name'] = sfManualEscape($objPage->list_data['name']); 210 $objPage->arrHidden = lfGetHidden($objPage->list_data); // hiddenÍ×ÁǺîÀ® 211 212 $objPage->tpl_mainpage = 'mail/input.tpl'; 213 $template_data = getTemplateData($conn, $_POST['template_id']); 214 if ( $template_data ){ 215 foreach( $template_data as $key=>$val ){ 216 $objPage->list_data[$key] = $val; 217 } 218 } 219 220 //-- HTML¥Æ¥ó¥×¥ì¡¼¥È¤ò»ÈÍѤ¹¤ë¾ì¹ç¤Ï¡¢HTML¥½¡¼¥¹¤òÀ¸À®¤·¤ÆBODY¤ØÁÞÆþ 221 if ( $objPage->list_data["mail_method"] == 3) { 222 $objTemplate = new LC_HTMLtemplate; 223 $objTemplate->list_data = lfGetHtmlTemplateData($_POST['template_id']); 224 $objSiteInfo = new SC_SiteInfo(); 225 $objTemplate->arrInfo = $objSiteInfo->data; 226 //¥á¡¼¥ëôÅö¼Ì¿¿¤Îɽ¼¨ 227 $objUpFile = new SC_UploadFile(IMAGE_TEMP_URL, IMAGE_SAVE_URL); 228 $objUpFile->addFile("¥á¡¼¥ëôÅö¼Ì¿¿", 'charge_image', array('jpg'), IMAGE_SIZE, true, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); 229 $objUpFile->setDBFileList($objTemplate->list_data); 230 $objTemplate->arrFile = $objUpFile->getFormFileList(IMAGE_TEMP_URL, IMAGE_SAVE_URL); 231 $objMakeTemplate = new SC_AdminView(); 232 $objMakeTemplate->assignobj($objTemplate); 233 $objPage->list_data["body"] = $objMakeTemplate->fetch("mail/html_template.tpl"); 234 } 235 } 236 break; 237 /* 238 regist_confirm:¡ÖÆþÎÏÆâÍƤò³Îǧ¡× 239 regist_back:¡Ö¥Æ¥ó¥×¥ì¡¼¥ÈÀßÄê²èÌ̤ØÌá¤ë¡× 240 regist_complete:¡ÖÅÐÏ¿¡× 241 */ 242 242 case 'regist_confirm': 243 243 case 'regist_back': 244 244 case 'regist_complete': 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 245 //-- ÆþÎÏÃÍ¥³¥ó¥Ð¡¼¥È 246 $arrCheckColumn = array_merge( $arrSearchColumn, $arrRegistColumn ); 247 $objPage->list_data = lfConvertParam($_POST, $arrCheckColumn); 248 249 //¸½ºß»þ¹ï¤Î¼èÆÀ 250 $objPage->arrNowDate = lfGetNowDate(); 251 252 //-- ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 253 $objPage->arrErr = lfErrorCheck($objPage->list_data, 1); 254 $objPage->tpl_mainpage = 'mail/input.tpl'; 255 $objPage->arrHidden = lfGetHidden($objPage->list_data); // hiddenÍ×ÁǺîÀ® 256 257 //-- ¸¡º÷³«»Ï 258 if ( ! is_array($objPage->arrErr)) { 259 $objPage->list_data['name'] = sfManualEscape($objPage->list_data['name']); 260 if ( $_POST['mode'] == 'regist_confirm'){ 261 $objPage->tpl_mainpage = 'mail/input_confirm.tpl'; 262 } else if( $_POST['mode'] == 'regist_complete' ){ 263 lfRegistData($objPage->list_data); 264 264 //¥á¥ë¥Þ¥¬µ¡Ç½¤¬¥ª¥ó¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤«¤É¤¦¤«¤ÎȽÄê 265 265 if(MELMAGA_SEND == true) { 266 266 //ͽÌóÇÛ¿®¥â¡¼¥É¤Îʬ´ô 267 268 269 } else { 270 271 272 273 274 275 276 277 278 267 if(MELMAGA_BATCH_MODE) { 268 header("Location: " . URL_DIR . "admin/mail/history.php"); 269 } else { 270 header("Location: " . URL_DIR . "admin/mail/sendmail.php?mode=now"); 271 } 272 exit; 273 } else { 274 sfErrorHeader(">> ËÜ¥µ¥¤¥È¤Ç¤Ï¥á¥ë¥Þ¥¬ÇÛ¿®¤Ï¹Ô¤¨¤Þ¤»¤ó¡£"); 275 } 276 } 277 } 278 break; 279 279 default: 280 281 280 $objPage->list_data['mail_type'] = 1; 281 break; 282 282 } 283 283 284 284 // ÇÛ¿®»þ´Ö¤Îǯ¤ò¡¢¡Ö¸½ºßǯ¢·¸½ºßǯ¡Ü£±¡×¤ÎÈϰϤËÀßÄê 285 285 for ($year=date("Y"); $year<=date("Y") + 1;$year++){ 286 $arrYear[$year] = $year; 287 } 288 289 $objPage->arrIP = lfGetBlayn(); 290 286 $arrYear[$year] = $year; 287 } 291 288 $objPage->arrYear = $arrYear; 292 $objPage->errorCount = count($objPage->arrErr);293 294 289 295 290 $objPage->arrCustomerOrderId = lfGetCustomerOrderId($_POST['buy_product_code']); … … 298 293 299 294 $objPage->arrCampaignList = lfGetCampaignList(); 300 sfprintr(count($objPage->arrErr)); 295 301 296 //----¡¡¥Ú¡¼¥¸É½¼¨ 302 297 $objView->assignobj($objPage); … … 307 302 // ¾¦ÉÊ¥³¡¼¥É¤Ç¸¡º÷¤µ¤ì¤¿¾ì¹ç¤Ë¥Ò¥Ã¥È¤·¤¿¼õÃíÈÖ¹æ¤ò¼èÆÀ¤¹¤ë¡£ 308 303 function lfGetCustomerOrderId($keyword) { 309 310 311 312 313 314 315 316 317 318 319 320 return $arrCustomerOrderId; 304 if($keyword != "") { 305 $col = "dtb_order.customer_id, dtb_order.order_id"; 306 $from = "dtb_order LEFT JOIN dtb_order_detail USING(order_id)"; 307 $where = "product_code LIKE ? AND del_flg = 0"; 308 $val = sfManualEscape($keyword); 309 $arrVal[] = "%$val%"; 310 $objQuery = new SC_Query(); 311 $objQuery->setgroupby("customer_id, order_id"); 312 $arrRet = $objQuery->select($col, $from, $where, $arrVal); 313 $arrCustomerOrderId = sfArrKeyValues($arrRet, "customer_id", "order_id"); 314 } 315 return $arrCustomerOrderId; 321 316 } 322 317 323 318 function lfMakeCsvData( $send_id ){ 324 325 326 327 $arrTitle = array('name01','email');328 329 330 331 332 333 334 335 return $return; 319 320 global $conn; 321 322 $arrTitle = array( 'name01','email'); 323 324 $sql = "SELECT name01,email FROM dtb_send_customer WHERE send_id = ? ORDER BY email"; 325 $result = $conn->getAll($sql, array($send_id) ); 326 327 if ( $result ){ 328 $return = lfGetCSVData( $result, $arrTitle); 329 } 330 return $return; 336 331 } 337 332 338 333 //---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ 339 function lfGetCSVData( $array, $arrayIndex){ 340 341 342 343 344 345 $return .= "\""; 346 347 $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\""; 348 349 350 351 352 $return .= "\n"; 353 354 334 function lfGetCSVData( $array, $arrayIndex){ 335 336 for ($i=0; $i<count($array); $i++){ 337 338 for ($j=0; $j<count($array[$i]); $j++ ){ 339 if ( $j > 0 ) $return .= ","; 340 $return .= "\""; 341 if ( $arrayIndex ){ 342 $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\""; 343 } else { 344 $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\""; 345 } 346 } 347 $return .= "\n"; 348 } 349 return $return; 355 350 } 356 351 357 352 //¸½ºß»þ¹ï¤Î¼èÆÀ¡ÊÇÛ¿®»þ´Ö¥Ç¥Õ¥©¥ë¥ÈÃÍ¡Ë 358 353 function lfGetNowDate(){ 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 354 $nowdate = date("Y/n/j/G/i"); 355 list($year, $month, $day, $hour, $minute) = split("[/]", $nowdate); 356 $arrNowDate = array( 'year' => $year, 'month' => $month, 'day' => $day, 'hour' => $hour, 'minutes' => $minute); 357 foreach ($arrNowDate as $key => $val){ 358 switch ($key){ 359 case 'minutes': 360 $val = ereg_replace('^[0]','', $val); 361 if ($val < 30){ 362 $list_date[$key] = '30'; 363 }else{ 364 $list_date[$key] = '00'; 365 } 366 break; 367 case 'year': 368 case 'month': 369 case 'day': 370 $list_date[$key] = $val; 371 break; 372 } 373 } 374 if ($arrNowDate['minutes'] < 30){ 375 $list_date['hour'] = $hour; 376 }else{ 377 $list_date['hour'] = $hour + 1; 378 } 379 return $list_date; 385 380 } 386 381 387 382 // ÇÛ¿®ÆâÍƤÈÇÛ¿®¥ê¥¹¥È¤ò½ñ¤¹þ¤à 388 383 function lfRegistData($arrData){ 389 390 391 392 393 394 395 396 397 398 399 384 385 global $conn; 386 global $arrSearchColumn; 387 388 $objQuery = new SC_Query(); 389 $objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" ); 390 391 $search_data = $conn->getAll($objSelect->getListMailMagazine(lfGetIsMobile($_POST['mail_type'])), $objSelect->arrVal); 392 $dataCnt = count($search_data); 393 $dtb_send_history = array(); 394 400 395 if(DB_TYPE == "pgsql"){ 401 396 $dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id'); 402 397 } 403 398 404 399 $dtb_send_history["mail_method"] = $arrData['mail_method']; 405 406 407 408 400 $dtb_send_history["subject"] = $arrData['subject']; 401 $dtb_send_history["body"] = $arrData['body']; 402 if(MELMAGA_BATCH_MODE) { 403 //¥¤¥ó¥¹¥È¡¼¥ëÀè¤Î¥µ¡¼¥Ð¡¼¤ÇCRON¤¬Í¸ú¤Ç¤¢¤ë¤Ê¤é»ØÄꤵ¤ì¤¿»þ´Ö¤Ë¥á¡¼¥ë¤òÁ÷¤ë 409 404 $dtb_send_history["start_date"] = $arrData['send_year'] ."/".$arrData['send_month']."/".$arrData['send_day']." ".$arrData['send_hour'].":".$arrData['send_minutes']; 410 411 405 } else { 406 //CRON¤¬Ìµ¸ú¤Ç¤¢¤ì¤Ð¥ê¥¢¥ë¥¿¥¤¥à¤ËÁ÷¿®¤¹¤ë 412 407 $dtb_send_history["start_date"] = "now()"; 413 414 415 416 417 418 419 408 } 409 $dtb_send_history["creator_id"] = $_SESSION['member_id']; 410 $dtb_send_history["send_count"] = $dataCnt; 411 $arrData['body'] = ""; 412 $dtb_send_history["search_data"] = serialize($arrData); 413 $dtb_send_history["update_date"] = "now()"; 414 $dtb_send_history["create_date"] = "now()"; 420 415 421 416 //¥Ï¥Ã¥·¥ådtb_send_history¤ò¥Ç¡¼¥¿¥Ù¡¼¥¹dtb_send_history¤ËÁÞÆþ … … 425 420 } 426 421 427 422 if ( is_array( $search_data ) ){ 428 423 foreach( $search_data as $line ){ 429 424 430 425 $dtb_send_customer = array(); 431 432 433 434 435 $conn->autoExecute("dtb_send_customer", $dtb_send_customer ); 426 $dtb_send_customer["customer_id"] = $line["customer_id"]; 427 $dtb_send_customer["send_id"] = $dtb_send_history["send_id"]; 428 $dtb_send_customer["email"] = $line["email"]; 429 $dtb_send_customer["name"] = $line["name01"] . " " . $line["name02"]; 430 $conn->autoExecute("dtb_send_customer", $dtb_send_customer ); 436 431 437 } 438 432 } 433 } 439 434 } 440 435 441 436 // ¥¥ã¥ó¥Ú¡¼¥ó°ìÍ÷ 442 437 function lfGetCampaignList() { 443 444 445 446 447 448 449 450 451 452 438 439 global $objQuery; 440 441 $sql = "SELECT campaign_id, campaign_name FROM dtb_campaign ORDER BY update_date DESC"; 442 $arrResult = $objQuery->getall($sql); 443 444 foreach($arrResult as $arrVal) { 445 $arrCampaign[$arrVal['campaign_id']] = $arrVal['campaign_name']; 446 } 447 return $arrCampaign; 453 448 } 454 449 455 450 function lfGetIsMobile($mail_type) { 456 // ¸¡º÷·ë²Ì¤Î¼èÆÀ 457 $is_mobile = false; 458 switch($mail_type) { 459 case 1: 460 $is_mobile = false; 461 break; 462 case 2: 463 $is_mobile = true; 464 break; 465 default: 466 $is_mobile = false; 467 break; 468 } 469 470 return $is_mobile; 471 } 472 473 // ¥Ö¥ì¥¤¥ó¥¨¥ó¥¸¥ó¤¬ÀßÄêºÑ¤ß¤«³Îǧ 474 function lfGetBlayn() { 475 476 global $objQuery; 477 478 $arrRet = $objQuery->count("dtb_blayn"); 479 480 return $arrRet; 451 // ¸¡º÷·ë²Ì¤Î¼èÆÀ 452 $is_mobile = false; 453 switch($mail_type) { 454 case 1: 455 $is_mobile = false; 456 break; 457 case 2: 458 $is_mobile = true; 459 break; 460 default: 461 $is_mobile = false; 462 break; 463 } 464 465 return $is_mobile; 481 466 } 482 467 ?>
Note: See TracChangeset
for help on using the changeset viewer.