Source for file LC_Page_Admin_Order.php
Documentation is available at LC_Page_Admin_Order.php
* This file is part of EC-CUBE
* Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
* http://www.lockon.co.jp/
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
require_once(CLASS_PATH .
"pages/LC_Page.php");
if (file_exists(MODULE_PATH .
'mdl_paygent/include.php') ===
TRUE) {
require_once(MODULE_PATH .
'mdl_paygent/include.php');
* @author LOCKON CO.,LTD.
$this->tpl_subnavi =
'order/subnavi.tpl';
$this->tpl_subno =
'index';
$this->tpl_pager =
TEMPLATE_DIR .
'admin/pager.tpl';
$this->tpl_subtitle =
'受注管理';
$this->arrORDERSTATUS =
$masterData->getMasterData("mtb_order_status");
$this->arrORDERSTATUS_COLOR =
$masterData->getMasterData("mtb_order_status_color");
$this->arrSex =
$masterData->getMasterData("mtb_sex");
$this->arrPageMax =
$masterData->getMasterData("mtb_page_max");
$this->arrDispKind =
sfPaygentOrderPage();
$this->objFormParam->setParam($_POST);
$this->objFormParam->splitParamCheckBoxes('search_order_sex');
$this->objFormParam->splitParamCheckBoxes('search_payment_id');
foreach ($_POST as $key =>
$val) {
if (ereg("^search_", $key)) {
case 'search_payment_id':
$this->arrHidden[$key] =
SC_Utils_Ex::sfMergeParamCheckBoxes($val);
$this->arrHidden[$key] =
$val;
$this->arrHidden['search_pageno'] =
isset
($_POST['search_pageno']) ?
$_POST['search_pageno'] :
"";
if (!isset
($_POST['mode'])) $_POST['mode'] =
"";
if (!isset
($arrRet)) $arrRet =
array();
if($_POST['mode'] ==
'delete') {
$sqlval['del_flg'] =
'1';
$objQuery->update("dtb_order", $sqlval, $where, array($_POST['order_id']));
$this->objFormParam->convParam();
$arrRet =
$this->objFormParam->getHashArray();
if (count($this->arrErr) ==
0) {
foreach ($arrRet as $key =>
$val) {
case 'search_product_name':
// $val = mb_convert_encoding($val,"UTF-8",mb_detect_encoding($val));
$where .=
" AND (SELECT COUNT(*) FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name ILIKE ?) > 0";
$arrval[] =
"%$nonsp_val%";
}elseif(DB_TYPE ==
"mysql"){
$where .=
" AND (SELECT COUNT(*) FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?) > 0";
$arrval[] =
"%$nonsp_val%";
case 'search_order_name':
$where .=
" AND order_name01||order_name02 ILIKE ?";
}elseif(DB_TYPE ==
"mysql"){
$where .=
" AND concat(order_name01,order_name02) ILIKE ?";
$arrval[] =
"%$nonsp_val%";
case 'search_order_kana':
$where .=
" AND order_kana01||order_kana02 ILIKE ?";
}elseif(DB_TYPE ==
"mysql"){
$where .=
" AND concat(order_kana01,order_kana02) ILIKE ?";
$arrval[] =
"%$nonsp_val%";
$where .=
" AND order_id >= ?";
$where .=
" AND order_id <= ?";
foreach($val as $element) {
$tmp_where .=
" AND (order_sex = ?";
$tmp_where .=
" OR order_sex = ?";
$where .=
" $tmp_where ";
$where .=
" AND (order_tel01 || order_tel02 || order_tel03 ILIKE ?)";
}elseif(DB_TYPE ==
"mysql"){
$where .=
" AND concat(order_tel01,order_tel02,order_tel03) ILIKE ?";
$arrval[] =
"%$nonmark_val%";
case 'search_order_email':
$where .=
" AND order_email ILIKE ?";
case 'search_payment_id':
foreach($val as $element) {
$tmp_where .=
" AND (payment_id = ?";
$tmp_where .=
" OR payment_id = ?";
$where .=
" $tmp_where ";
$where .=
" AND total >= ?";
$where .=
" AND total <= ?";
case 'search_sorderyear':
$date =
SC_Utils_Ex::sfGetTimestamp($_POST['search_sorderyear'], $_POST['search_sordermonth'], $_POST['search_sorderday']);
$where.=
" AND create_date >= ?";
case 'search_eorderyear':
$date =
SC_Utils_Ex::sfGetTimestamp($_POST['search_eorderyear'], $_POST['search_eordermonth'], $_POST['search_eorderday'], true);
$where.=
" AND create_date <= ?";
case 'search_supdateyear':
$date =
SC_Utils_Ex::sfGetTimestamp($_POST['search_supdateyear'], $_POST['search_supdatemonth'], $_POST['search_supdateday']);
$where.=
" AND update_date >= ?";
case 'search_eupdateyear':
$date =
SC_Utils_Ex::sfGetTimestamp($_POST['search_eupdateyear'], $_POST['search_eupdatemonth'], $_POST['search_eupdateday'], true);
$where.=
" AND update_date <= ?";
case 'search_sbirthyear':
$date =
SC_Utils_Ex::sfGetTimestamp($_POST['search_sbirthyear'], $_POST['search_sbirthmonth'], $_POST['search_sbirthday']);
$where.=
" AND order_birth >= ?";
case 'search_ebirthyear':
$date =
SC_Utils_Ex::sfGetTimestamp($_POST['search_ebirthyear'], $_POST['search_ebirthmonth'], $_POST['search_ebirthday'], true);
$where.=
" AND order_birth <= ?";
case 'search_order_status':
$where.=
" AND status = ?";
if (!isset
($arrval)) $arrval =
array();
$order =
"update_date DESC";
require_once(CLASS_EX_PATH .
"helper_extends/SC_Helper_CSV_Ex.php");
$option =
"ORDER BY $order";
$arrCsvOutput =
SC_Utils_Ex::sfSwapArray($objCSV->sfgetCsvOutput(3, " WHERE csv_id = 3 AND status = 1"));
if (count($arrCsvOutput) <=
0) break;
$arrCsvOutputCols =
$arrCsvOutput['col'];
$arrCsvOutputTitle =
$arrCsvOutput['disp_name'];
$data =
$objCSV->lfGetCSV("dtb_order", $where, $option, $arrval, $arrCsvOutputCols);
$objFpdf->setData($arrRet);
$objQuery->update("dtb_order", $sqlval, $where, $arrval);
$linemax =
$objQuery->count($from, $where, $arrval);
$this->tpl_linemax =
$linemax; // 何件が該当しました。表示用
$page_max =
$_POST['search_page_max'];
$objNavi =
new SC_PageNavi($this->arrHidden['search_pageno'],
"fnNaviSearchPage", NAVI_PMAX);
$startno =
$objNavi->start_row;
$this->arrPagenavi =
$objNavi->arrPagenavi;
$objQuery->setlimitoffset($page_max, $startno);
$objQuery->setorder($order);
$this->arrResults =
$objQuery->select($col, $from, $where, $arrval);
$objDate->setStartYear(RELEASE_YEAR);
$objDate->setEndYear(DATE("Y"));
$this->arrRegistYear =
$objDate->getYear();
$objDate->setStartYear(BIRTH_YEAR);
$objDate->setEndYear(DATE("Y"));
$this->arrBirthYear =
$objDate->getYear();
$this->arrMonth =
$objDate->getMonth();
$this->arrDay =
$objDate->getDay();
$this->arrForm =
$this->objFormParam->getFormParamList();
$arrRet =
$objDb->sfGetPayment();
$this->arrPayment =
SC_Utils_Ex::sfArrKeyValue($arrRet, 'payment_id', 'payment_method');
$objView->assignobj($this);
$objView->display(MAIN_FRAME);
$this->objFormParam->addParam("受注番号1", "search_order_id1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("受注番号2", "search_order_id2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("対応状況", "search_order_status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("顧客名", "search_order_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
$this->objFormParam->addParam("顧客名(カナ)", "search_order_kana", STEXT_LEN, "KVCa", array("KANA_CHECK","MAX_LENGTH_CHECK"));
$this->objFormParam->addParam("性別", "search_order_sex", INT_LEN, "n", array("MAX_LENGTH_CHECK"));
$this->objFormParam->addParam("年齢1", "search_age1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("年齢2", "search_age2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("メールアドレス", "search_order_email", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
$this->objFormParam->addParam("TEL", "search_order_tel", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
$this->objFormParam->addParam("支払い方法", "search_payment_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("購入金額1", "search_total1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("購入金額2", "search_total2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("表示件数", "search_page_max", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始年", "search_sorderyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始月", "search_sordermonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始日", "search_sorderday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了年", "search_eorderyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了月", "search_eordermonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了日", "search_eorderday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始年", "search_supdateyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始月", "search_supdatemonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始日", "search_supdateday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了年", "search_eupdateyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了月", "search_eupdatemonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了日", "search_eupdateday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始年", "search_sbirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始月", "search_sbirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("開始日", "search_sbirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了年", "search_ebirthyear", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了月", "search_ebirthmonth", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("終了日", "search_ebirthday", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
$this->objFormParam->addParam("購入商品","search_product_name",STEXT_LEN,"KVa",array("MAX_LENGTH_CHECK"));
$arrRet =
$this->objFormParam->getHashArray();
$objErr->arrErr =
$this->objFormParam->checkError();
$objErr->doFunc(array("受注番号1", "受注番号2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK"));
$objErr->doFunc(array("年齢1", "年齢2", "search_age1", "search_age2"), array("GREATER_CHECK"));
$objErr->doFunc(array("購入金額1", "購入金額2", "search_total1", "search_total2"), array("GREATER_CHECK"));
$objErr->doFunc(array("開始", "search_sorderyear", "search_sordermonth", "search_sorderday"), array("CHECK_DATE"));
$objErr->doFunc(array("終了", "search_eorderyear", "search_eordermonth", "search_eorderday"), array("CHECK_DATE"));
$objErr->doFunc(array("開始", "終了", "search_sorderyear", "search_sordermonth", "search_sorderday", "search_eorderyear", "search_eordermonth", "search_eorderday"), array("CHECK_SET_TERM"));
$objErr->doFunc(array("開始", "search_supdateyear", "search_supdatemonth", "search_supdateday"), array("CHECK_DATE"));
$objErr->doFunc(array("終了", "search_eupdateyear", "search_eupdatemonth", "search_eupdateday"), array("CHECK_DATE"));
$objErr->doFunc(array("開始", "終了", "search_supdateyear", "search_supdatemonth", "search_supdateday", "search_eupdateyear", "search_eupdatemonth", "search_eupdateday"), array("CHECK_SET_TERM"));
$objErr->doFunc(array("開始", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday"), array("CHECK_DATE"));
$objErr->doFunc(array("終了", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_DATE"));
$objErr->doFunc(array("開始", "終了", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array("CHECK_SET_TERM"));
Documentation generated on Tue, 28 Apr 2009 18:11:21 +0900 by phpDocumentor 1.4.2