Changeset 14322
- Timestamp:
- 2007/06/05 21:18:28 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/admin/mail/index.php
r14321 r14322 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 } 286 $arrYear[$year] = $year; 287 } 288 289 $objPage->arrIP = lfGetBlayn(); 290 288 291 $objPage->arrYear = $arrYear; 292 $objPage->errorCount = count($objPage->arrErr); 293 289 294 290 295 $objPage->arrCustomerOrderId = lfGetCustomerOrderId($_POST['buy_product_code']); … … 293 298 294 299 $objPage->arrCampaignList = lfGetCampaignList(); 295 300 sfprintr(count($objPage->arrErr)); 296 301 //----¡¡¥Ú¡¼¥¸É½¼¨ 297 302 $objView->assignobj($objPage); … … 302 307 // ¾¦ÉÊ¥³¡¼¥É¤Ç¸¡º÷¤µ¤ì¤¿¾ì¹ç¤Ë¥Ò¥Ã¥È¤·¤¿¼õÃíÈÖ¹æ¤ò¼èÆÀ¤¹¤ë¡£ 303 308 function lfGetCustomerOrderId($keyword) { 304 305 306 307 308 309 310 311 312 313 314 315 return $arrCustomerOrderId; 309 if($keyword != "") { 310 $col = "dtb_order.customer_id, dtb_order.order_id"; 311 $from = "dtb_order LEFT JOIN dtb_order_detail USING(order_id)"; 312 $where = "product_code LIKE ? AND del_flg = 0"; 313 $val = sfManualEscape($keyword); 314 $arrVal[] = "%$val%"; 315 $objQuery = new SC_Query(); 316 $objQuery->setgroupby("customer_id, order_id"); 317 $arrRet = $objQuery->select($col, $from, $where, $arrVal); 318 $arrCustomerOrderId = sfArrKeyValues($arrRet, "customer_id", "order_id"); 319 } 320 return $arrCustomerOrderId; 316 321 } 317 322 318 323 function lfMakeCsvData( $send_id ){ 319 320 321 322 $arrTitle = array('name01','email');323 324 325 326 327 328 329 330 return $return; 324 325 global $conn; 326 327 $arrTitle = array( 'name01','email'); 328 329 $sql = "SELECT name01,email FROM dtb_send_customer WHERE send_id = ? ORDER BY email"; 330 $result = $conn->getAll($sql, array($send_id) ); 331 332 if ( $result ){ 333 $return = lfGetCSVData( $result, $arrTitle); 334 } 335 return $return; 331 336 } 332 337 333 338 //---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ 334 function lfGetCSVData( $array, $arrayIndex){ 335 336 337 338 339 340 $return .= "\""; 341 342 $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\""; 343 344 345 346 347 $return .= "\n"; 348 349 339 function lfGetCSVData( $array, $arrayIndex){ 340 341 for ($i=0; $i<count($array); $i++){ 342 343 for ($j=0; $j<count($array[$i]); $j++ ){ 344 if ( $j > 0 ) $return .= ","; 345 $return .= "\""; 346 if ( $arrayIndex ){ 347 $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\""; 348 } else { 349 $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\""; 350 } 351 } 352 $return .= "\n"; 353 } 354 return $return; 350 355 } 351 356 352 357 //¸½ºß»þ¹ï¤Î¼èÆÀ¡ÊÇÛ¿®»þ´Ö¥Ç¥Õ¥©¥ë¥ÈÃÍ¡Ë 353 358 function lfGetNowDate(){ 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 359 $nowdate = date("Y/n/j/G/i"); 360 list($year, $month, $day, $hour, $minute) = split("[/]", $nowdate); 361 $arrNowDate = array( 'year' => $year, 'month' => $month, 'day' => $day, 'hour' => $hour, 'minutes' => $minute); 362 foreach ($arrNowDate as $key => $val){ 363 switch ($key){ 364 case 'minutes': 365 $val = ereg_replace('^[0]','', $val); 366 if ($val < 30){ 367 $list_date[$key] = '30'; 368 }else{ 369 $list_date[$key] = '00'; 370 } 371 break; 372 case 'year': 373 case 'month': 374 case 'day': 375 $list_date[$key] = $val; 376 break; 377 } 378 } 379 if ($arrNowDate['minutes'] < 30){ 380 $list_date['hour'] = $hour; 381 }else{ 382 $list_date['hour'] = $hour + 1; 383 } 384 return $list_date; 380 385 } 381 386 382 387 // ÇÛ¿®ÆâÍƤÈÇÛ¿®¥ê¥¹¥È¤ò½ñ¤¹þ¤à 383 388 function lfRegistData($arrData){ 384 385 386 387 388 389 390 391 392 393 394 389 390 global $conn; 391 global $arrSearchColumn; 392 393 $objQuery = new SC_Query(); 394 $objSelect = new SC_CustomerList( lfConvertParam($arrData, $arrSearchColumn), "magazine" ); 395 396 $search_data = $conn->getAll($objSelect->getListMailMagazine(lfGetIsMobile($_POST['mail_type'])), $objSelect->arrVal); 397 $dataCnt = count($search_data); 398 $dtb_send_history = array(); 399 395 400 if(DB_TYPE == "pgsql"){ 396 401 $dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id'); 397 402 } 398 403 399 404 $dtb_send_history["mail_method"] = $arrData['mail_method']; 400 401 402 403 405 $dtb_send_history["subject"] = $arrData['subject']; 406 $dtb_send_history["body"] = $arrData['body']; 407 if(MELMAGA_BATCH_MODE) { 408 //¥¤¥ó¥¹¥È¡¼¥ëÀè¤Î¥µ¡¼¥Ð¡¼¤ÇCRON¤¬Í¸ú¤Ç¤¢¤ë¤Ê¤é»ØÄꤵ¤ì¤¿»þ´Ö¤Ë¥á¡¼¥ë¤òÁ÷¤ë 404 409 $dtb_send_history["start_date"] = $arrData['send_year'] ."/".$arrData['send_month']."/".$arrData['send_day']." ".$arrData['send_hour'].":".$arrData['send_minutes']; 405 406 410 } else { 411 //CRON¤¬Ìµ¸ú¤Ç¤¢¤ì¤Ð¥ê¥¢¥ë¥¿¥¤¥à¤ËÁ÷¿®¤¹¤ë 407 412 $dtb_send_history["start_date"] = "now()"; 408 409 410 411 412 413 414 413 } 414 $dtb_send_history["creator_id"] = $_SESSION['member_id']; 415 $dtb_send_history["send_count"] = $dataCnt; 416 $arrData['body'] = ""; 417 $dtb_send_history["search_data"] = serialize($arrData); 418 $dtb_send_history["update_date"] = "now()"; 419 $dtb_send_history["create_date"] = "now()"; 415 420 416 421 //¥Ï¥Ã¥·¥ådtb_send_history¤ò¥Ç¡¼¥¿¥Ù¡¼¥¹dtb_send_history¤ËÁÞÆþ … … 420 425 } 421 426 422 427 if ( is_array( $search_data ) ){ 423 428 foreach( $search_data as $line ){ 424 429 425 430 $dtb_send_customer = array(); 426 427 428 429 430 $conn->autoExecute("dtb_send_customer", $dtb_send_customer ); 431 $dtb_send_customer["customer_id"] = $line["customer_id"]; 432 $dtb_send_customer["send_id"] = $dtb_send_history["send_id"]; 433 $dtb_send_customer["email"] = $line["email"]; 434 $dtb_send_customer["name"] = $line["name01"] . " " . $line["name02"]; 435 $conn->autoExecute("dtb_send_customer", $dtb_send_customer ); 431 436 432 } 433 437 } 438 } 434 439 } 435 440 436 441 // ¥¥ã¥ó¥Ú¡¼¥ó°ìÍ÷ 437 442 function lfGetCampaignList() { 443 444 global $objQuery; 445 446 $sql = "SELECT campaign_id, campaign_name FROM dtb_campaign ORDER BY update_date DESC"; 447 $arrResult = $objQuery->getall($sql); 448 449 foreach($arrResult as $arrVal) { 450 $arrCampaign[$arrVal['campaign_id']] = $arrVal['campaign_name']; 451 } 452 return $arrCampaign; 453 } 454 455 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() { 438 475 439 476 global $objQuery; 440 477 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; 448 } 449 450 function lfGetIsMobile($mail_type) { 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 } 478 $arrRet = $objQuery->count("dtb_blayn"); 464 479 465 return $ is_mobile;480 return $arrRet; 466 481 } 467 482 ?>
Note: See TracChangeset
for help on using the changeset viewer.