- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/total/LC_Page_Admin_Total.php
r21490 r21514 65 65 66 66 // ページタイトル todo あとでなおす 67 $this->arrTitle[''] = "期間別集計";68 $this->arrTitle['term'] = "期間別集計";69 $this->arrTitle['products'] = "商品別集計";70 $this->arrTitle['age'] = "年代別集計";71 $this->arrTitle['job'] = "職業別集計";72 $this->arrTitle['member'] = "会員別集計";67 $this->arrTitle[''] = '期間別集計'; 68 $this->arrTitle['term'] = '期間別集計'; 69 $this->arrTitle['products'] = '商品別集計'; 70 $this->arrTitle['age'] = '年代別集計'; 71 $this->arrTitle['job'] = '職業別集計'; 72 $this->arrTitle['member'] = '会員別集計'; 73 73 74 74 // 月度集計のkey名 … … 132 132 $type = ($objFormParam->getValue('type')) ? $objFormParam->getValue('type'): 'all'; 133 133 134 $this->tpl_page_type = "total/page_". $page .".tpl";134 $this->tpl_page_type = 'total/page_'. $page .'.tpl'; 135 135 list($this->arrResults, $this->tpl_image) = call_user_func_array(array($this, 'lfGetOrder'.$page), 136 136 array($type, $sdate, $edate)); … … 201 201 202 202 // 月度集計 203 $objFormParam->addParam( "月度", 'search_startyear_m', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startyear_m']);204 $objFormParam->addParam( "月度", 'search_startmonth_m', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startmonth_m']);203 $objFormParam->addParam('月度', 'search_startyear_m', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startyear_m']); 204 $objFormParam->addParam('月度', 'search_startmonth_m', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startmonth_m']); 205 205 // 期間集計 206 $objFormParam->addParam( "開始日", 'search_startyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startyear']);207 $objFormParam->addParam( "開始日", 'search_startmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startmonth']);208 $objFormParam->addParam( "開始日", 'search_startday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startday']);209 $objFormParam->addParam( "終了日", 'search_endyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['endyear']);210 $objFormParam->addParam( "終了日", 'search_endmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['endmonth']);211 $objFormParam->addParam( "終了日", 'search_endday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['endday']);206 $objFormParam->addParam('開始日', 'search_startyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startyear']); 207 $objFormParam->addParam('開始日', 'search_startmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startmonth']); 208 $objFormParam->addParam('開始日', 'search_startday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['startday']); 209 $objFormParam->addParam('終了日', 'search_endyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['endyear']); 210 $objFormParam->addParam('終了日', 'search_endmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['endmonth']); 211 $objFormParam->addParam('終了日', 'search_endday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), $arrList['endday']); 212 212 213 213 // hiddenデータの取得用 214 $objFormParam->addParam( "", 'page');215 $objFormParam->addParam( "", 'type');216 $objFormParam->addParam( "", 'mode');217 $objFormParam->addParam( "", 'form');214 $objFormParam->addParam('', 'page'); 215 $objFormParam->addParam('', 'type'); 216 $objFormParam->addParam('', 'mode'); 217 $objFormParam->addParam('', 'form'); 218 218 } 219 219 … … 227 227 // 特殊項目チェック 228 228 if ($objFormParam->getValue('form') == 1) { 229 $objErr->doFunc(array( "月度", 'search_startyear_m'), array('ONE_EXIST_CHECK'));229 $objErr->doFunc(array('月度', 'search_startyear_m'), array('ONE_EXIST_CHECK')); 230 230 } 231 231 232 232 if ($objFormParam->getValue('form') == 2) { 233 $objErr->doFunc(array( "期間", 'search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday'), array('FULL_EXIST_CHECK'));234 } 235 $objErr->doFunc(array( "月度", 'search_startyear_m', 'search_startmonth_m'), array('ALL_EXIST_CHECK'));236 $objErr->doFunc(array( "開始日", 'search_startyear', 'search_startmonth', 'search_startday'), array('CHECK_DATE'));237 $objErr->doFunc(array( "終了日", 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_DATE'));238 $objErr->doFunc(array( "開始日", "終了日", 'search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_SET_TERM'));233 $objErr->doFunc(array('期間', 'search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday'), array('FULL_EXIST_CHECK')); 234 } 235 $objErr->doFunc(array('月度', 'search_startyear_m', 'search_startmonth_m'), array('ALL_EXIST_CHECK')); 236 $objErr->doFunc(array('開始日', 'search_startyear', 'search_startmonth', 'search_startday'), array('CHECK_DATE')); 237 $objErr->doFunc(array('終了日', 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_DATE')); 238 $objErr->doFunc(array('開始日', '終了日', 'search_startyear', 'search_startmonth', 'search_startday', 'search_endyear', 'search_endmonth', 'search_endday'), array('CHECK_SET_TERM')); 239 239 return $objErr->arrErr; 240 240 } … … 270 270 271 271 foreach ($arrRet as $key => $val) { 272 if ($val == "") {272 if ($val == '') { 273 273 continue; 274 274 } 275 275 switch ($key) { 276 276 case 'search_startyear': 277 $sdate = $objFormParam->getValue('search_startyear') . "/". $objFormParam->getValue('search_startmonth') . "/" . $objFormParam->getValue('search_startday');277 $sdate = $objFormParam->getValue('search_startyear') . '/' . $objFormParam->getValue('search_startmonth') . "/" . $objFormParam->getValue('search_startday'); 278 278 break; 279 279 case 'search_endyear': 280 $edate = $objFormParam->getValue('search_endyear') . "/". $objFormParam->getValue('search_endmonth') . "/" . $objFormParam->getValue('search_endday');280 $edate = $objFormParam->getValue('search_endyear') . '/' . $objFormParam->getValue('search_endmonth') . "/" . $objFormParam->getValue('search_endday'); 281 281 break; 282 282 case 'search_startyear_m': … … 296 296 function lfGetGraphLine($arrResults, $keyname, $type, $xtitle, $ytitle, $sdate, $edate, $xincline) { 297 297 298 $ret_path = "";298 $ret_path = ''; 299 299 300 300 // 結果が0行以上ある場合のみグラフを生成する。 … … 330 330 331 331 // メインタイトル作成 332 list($sy, $sm, $sd) = preg_split( "|[/ ]|", $sdate);333 list($ey, $em, $ed) = preg_split( "|[/ ]|", $edate);334 $start_date = $sy . "年" . $sm . "月". $sd . "日";335 $end_date = $ey . "年" . $em . "月". $ed . "日";336 $objGraphLine->drawTitle( "集計期間:" . $start_date . " - ". $end_date);332 list($sy, $sm, $sd) = preg_split('|[/ ]|' , $sdate); 333 list($ey, $em, $ed) = preg_split('|[/ ]|' , $edate); 334 $start_date = $sy . '年' . $sm . '月' . $sd . "日"; 335 $end_date = $ey . '年' . $em . '月' . $ed . "日"; 336 $objGraphLine->drawTitle('集計期間:' . $start_date . ' - ' . $end_date); 337 337 338 338 // グラフ描画 … … 352 352 353 353 // 円グラフの作成 354 function lfGetGraphPie($arrResults, $keyname, $type, $title = "", $sdate = "", $edate = "") {355 356 $ret_path = "";354 function lfGetGraphPie($arrResults, $keyname, $type, $title = '', $sdate = '', $edate = "") { 355 356 $ret_path = ''; 357 357 // 結果が0行以上ある場合のみグラフを生成する。 358 358 if (count($arrResults) > 0 && $this->install_GD) { … … 374 374 375 375 // メインタイトル作成 376 list($sy, $sm, $sd) = preg_split( "|[/ ]|", $sdate);377 list($ey, $em, $ed) = preg_split( "|[/ ]|", $edate);378 $start_date = $sy . "年" . $sm . "月". $sd . "日";379 $end_date = $ey . "年" . $em . "月". $ed . "日";380 $objGraphPie->drawTitle( "集計期間:" . $start_date . " - ". $end_date);376 list($sy, $sm, $sd) = preg_split('|[/ ]|' , $sdate); 377 list($ey, $em, $ed) = preg_split('|[/ ]|' , $edate); 378 $start_date = $sy . '年' . $sm . '月' . $sd . "日"; 379 $end_date = $ey . '年' . $em . '月' . $ed . "日"; 380 $objGraphPie->drawTitle('集計期間:' . $start_date . ' - ' . $end_date); 381 381 382 382 // 円グラフ描画 … … 397 397 // 棒グラフの作成 398 398 function lfGetGraphBar($arrResults, $keyname, $type, $xtitle, $ytitle, $sdate, $edate) { 399 $ret_path = "";399 $ret_path = ''; 400 400 401 401 // 結果が0行以上ある場合のみグラフを生成する。 … … 411 411 412 412 foreach (array_keys($arrList) as $val) { 413 $arrKey[] = ereg_replace( "~", "-", $val);413 $arrKey[] = ereg_replace('~', '-', $val); 414 414 } 415 415 … … 422 422 // メインタイトル作成 423 423 $arrKey = array_keys($arrList); 424 list($sy, $sm, $sd) = preg_split( "|[/ ]|", $sdate);425 list($ey, $em, $ed) = preg_split( "|[/ ]|", $edate);426 $start_date = $sy . "年" . $sm . "月". $sd . "日";427 $end_date = $ey . "年" . $em . "月". $ed . "日";428 $objGraphBar->drawTitle( "集計期間:" . $start_date . " - ". $end_date);424 list($sy, $sm, $sd) = preg_split('|[/ ]|' , $sdate); 425 list($ey, $em, $ed) = preg_split('|[/ ]|' , $edate); 426 $start_date = $sy . '年' . $sm . '月' . $sd . "日"; 427 $end_date = $ey . '年' . $em . '月' . $ed . "日"; 428 $objGraphBar->drawTitle('集計期間:' . $start_date . ' - ' . $end_date); 429 429 430 430 $objGraphBar->drawGraph(); … … 444 444 function lfGetGraphPng($keyname) { 445 445 446 if ($_POST['search_startyear_m'] != "") {447 $pngname = sprintf( "%s_%02d%02d.png", $keyname, substr($_POST['search_startyear_m'],2), $_POST['search_startmonth_m']);446 if ($_POST['search_startyear_m'] != '') { 447 $pngname = sprintf('%s_%02d%02d.png', $keyname, substr($_POST['search_startyear_m'],2), $_POST['search_startmonth_m']); 448 448 } else { 449 $pngname = sprintf( "%s_%02d%02d%02d_%02d%02d%02d.png", $keyname, substr($_POST['search_startyear'], 2), $_POST['search_startmonth'], $_POST['search_startday'], substr($_POST['search_endyear'],2), $_POST['search_endmonth'], $_POST['search_endday']);449 $pngname = sprintf('%s_%02d%02d%02d_%02d%02d%02d.png', $keyname, substr($_POST['search_startyear'], 2), $_POST['search_startmonth'], $_POST['search_startday'], substr($_POST['search_endyear'],2), $_POST['search_endmonth'], $_POST['search_endday']); 450 450 } 451 451 return $pngname; … … 454 454 // 会員、非会員集計のWHERE分の作成 455 455 function lfGetWhereMember($col_date, $sdate, $edate, $type, $col_member = 'customer_id') { 456 $where = "";456 $where = ''; 457 457 // 取得日付の指定 458 if ($sdate != "") {459 if ($where != "") {460 $where.= " AND ";458 if ($sdate != '') { 459 if ($where != '') { 460 $where.= ' AND '; 461 461 } 462 462 $where.= " $col_date >= '". $sdate ."'"; 463 463 } 464 464 465 if ($edate != "") {466 if ($where != "") {467 $where.= " AND ";468 } 469 $edate = date( "Y/m/d",strtotime("1 day",strtotime($edate)));465 if ($edate != '') { 466 if ($where != '') { 467 $where.= ' AND '; 468 } 469 $edate = date('Y/m/d',strtotime('1 day' ,strtotime($edate))); 470 470 $where.= " $col_date < date('" . $edate ."')"; 471 471 } … … 477 477 break; 478 478 case 'member': 479 if ($where != "") {480 $where.= " AND ";479 if ($where != '') { 480 $where.= ' AND '; 481 481 } 482 482 $where.= " $col_member <> 0"; 483 483 break; 484 484 case 'nonmember': 485 if ($where != "") {486 $where.= " AND ";485 if ($where != '') { 486 $where.= ' AND '; 487 487 } 488 488 $where.= " $col_member = 0"; … … 500 500 501 501 list($where, $arrval) = $this->lfGetWhereMember('create_date', $sdate, $edate, $type); 502 $where .= " AND del_flg = 0 AND status <> ". ORDER_CANCEL;502 $where .= ' AND del_flg = 0 AND status <> ' . ORDER_CANCEL; 503 503 504 504 // 会員集計の取得 … … 515 515 $from = 'dtb_order'; 516 516 517 $objQuery->setGroupBy( "member, order_sex");517 $objQuery->setGroupBy('member, order_sex'); 518 518 519 519 $arrTotalResults = $objQuery->select($col, $from, $where, $arrval); … … 522 522 $arrResult =& $arrTotalResults[$key]; 523 523 $member_key = $arrResult['order_sex']; 524 if ($member_key != "") {524 if ($member_key != '') { 525 525 $arrResult['member_name'] = (($arrResult['member']) ? '会員' : '非会員') . $this->arrSex[$member_key]; 526 526 } else { 527 $arrResult['member_name'] = "未回答";527 $arrResult['member_name'] = '未回答'; 528 528 } 529 529 } … … 540 540 list($where, $arrval) = $this->lfGetWhereMember('create_date', $sdate, $edate, $type); 541 541 542 $where .= " AND dtb_order.del_flg = 0 AND dtb_order.status <> ". ORDER_CANCEL;542 $where .= ' AND dtb_order.del_flg = 0 AND dtb_order.status <> ' . ORDER_CANCEL; 543 543 544 544 $col = " … … 551 551 (price * SUM(quantity)) AS total"; 552 552 553 $from = "dtb_order_detail JOIN dtb_order USING(order_id)";553 $from = 'dtb_order_detail JOIN dtb_order USING(order_id)'; 554 554 555 555 /* 556 556 if ($mode != 'csv') { 557 $sql.= "LIMIT ". PRODUCTS_TOTAL_MAX;557 $sql.= 'LIMIT ' . PRODUCTS_TOTAL_MAX; 558 558 }*/ 559 559 … … 583 583 $from = 'dtb_order JOIN dtb_customer USING ( customer_id)'; 584 584 585 $where .= " AND dtb_order.del_flg = 0 AND dtb_order.status <> ". ORDER_CANCEL;585 $where .= ' AND dtb_order.del_flg = 0 AND dtb_order.status <> ' . ORDER_CANCEL; 586 586 587 587 $objQuery->setGroupBy('job'); … … 592 592 $arrResult =& $arrTotalResults[$key]; 593 593 $job_key = $arrResult['job']; 594 if ($job_key != "") {594 if ($job_key != '') { 595 595 $arrResult['job_name'] = $this->arrJob[$job_key]; 596 596 } else { 597 $arrResult['job_name'] = "未回答";597 $arrResult['job_name'] = '未回答'; 598 598 } 599 599 … … 620 620 $from = 'dtb_order'; 621 621 622 $where .= " AND del_flg = 0 AND status <> ". ORDER_CANCEL;622 $where .= ' AND del_flg = 0 AND status <> ' . ORDER_CANCEL; 623 623 624 624 $objQuery->setGroupBy('age'); … … 629 629 $arrResult =& $arrTotalResults[$key]; 630 630 $age_key = $arrResult['age']; 631 if ($age_key != "") {631 if ($age_key != '') { 632 632 $arrResult['age_name'] = $arrResult['age'] . '代'; 633 633 } else { 634 $arrResult['age_name'] = "未回答";634 $arrResult['age_name'] = '未回答'; 635 635 } 636 636 … … 647 647 648 648 list($where, $arrval) = $this->lfGetWhereMember('create_date', $sdate, $edate); 649 $where .= " AND del_flg = 0 AND status <> ". ORDER_CANCEL;649 $where .= ' AND del_flg = 0 AND status <> ' . ORDER_CANCEL; 650 650 651 651 switch ($type) { 652 652 case 'month': 653 $xtitle = "(月別)";654 $ytitle = "(売上合計)";653 $xtitle = '(月別)'; 654 $ytitle = '(売上合計)'; 655 655 $format = '%m'; 656 656 break; 657 657 case 'year': 658 $xtitle = "(年別)";659 $ytitle = "(売上合計)";658 $xtitle = '(年別)'; 659 $ytitle = '(売上合計)'; 660 660 $format = '%Y'; 661 661 break; 662 662 case 'wday': 663 $xtitle = "(曜日別)";664 $ytitle = "(売上合計)";663 $xtitle = '(曜日別)'; 664 $ytitle = '(売上合計)'; 665 665 $format = '%a'; 666 666 break; 667 667 case 'hour': 668 $xtitle = "(時間別)";669 $ytitle = "(売上合計)";668 $xtitle = '(時間別)'; 669 $ytitle = '(売上合計)'; 670 670 $format = '%H'; 671 671 break; 672 672 default: 673 $xtitle = "(日別)";674 $ytitle = "(売上合計)";673 $xtitle = '(日別)'; 674 $ytitle = '(売上合計)'; 675 675 $format = '%Y-%m-%d'; 676 676 $xincline = true; … … 786 786 function lfGetDataColCSV($arrData, $arrDataCol) { 787 787 $max = count($arrData); 788 $csv_data = "";788 $csv_data = ''; 789 789 for ($i = 0; $i < $max; $i++) { 790 790 foreach ($arrDataCol as $val) {
Note: See TracChangeset
for help on using the changeset viewer.