Changeset 18177 for branches/version-2/data/class/pages/admin
- Timestamp:
- 2009/07/08 16:39:57 (17 years ago)
- Location:
- branches/version-2/data/class/pages/admin
- Files:
-
- 10 edited
-
LC_Page_Admin_Login.php (modified) (1 diff)
-
contents/LC_Page_Admin_Contents_CsvSql.php (modified) (4 diffs)
-
mail/LC_Page_Admin_Mail.php (modified) (2 diffs)
-
order/LC_Page_Admin_Order.php (modified) (3 diffs)
-
order/LC_Page_Admin_Order_Edit.php (modified) (6 diffs)
-
order/LC_Page_Admin_Order_Mail.php (modified) (1 diff)
-
order/LC_Page_Admin_Order_Pdf.php (modified) (2 diffs)
-
products/LC_Page_Admin_Products_Product.php (modified) (3 diffs)
-
products/LC_Page_Admin_Products_ReviewEdit.php (modified) (6 diffs)
-
products/LC_Page_Admin_Products_Trackback.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2/data/class/pages/admin/LC_Page_Admin_Login.php
r18176 r18177 70 70 $ret = $this->fnCheckPassword($conn); 71 71 } 72 73 72 if($ret) { 74 73 // 成功 -
branches/version-2/data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php
r18176 r18177 24 24 // {{{ requires 25 25 require_once(CLASS_PATH . "pages/LC_Page.php"); 26 require_once(CLASS_EX_PATH . "helper_extends/SC_Helper_CSV_Ex.php"); 26 27 27 28 /** … … 60 61 $objView = new SC_AdminView(); 61 62 $objDbFactory = SC_DB_DBFactory_Ex::getInstance(); 63 $objCSV = new SC_Helper_CSV_Ex(); 64 $this->arrSubnavi = $objCSV->arrSubnavi; 62 65 63 66 // 認証可否の判定 … … 148 151 $i ++; 149 152 } 150 $header .= "\ n\r";153 $header .= "\r\n"; 151 154 152 155 $data = SC_Utils_Ex::getCSVData($arrCsvOutputData, $arrKey); … … 212 215 213 216 // POSTされたデータをセットする 214 if ( count($_POST) > 0){217 if (isset($_POST['sql_name']) && isset($_POST['csv_sql'])){ 215 218 $arrSqlData[0]['sql_name'] = isset($_POST['sql_name']) ? $_POST['sql_name'] : ""; 216 219 $arrSqlData[0]['csv_sql'] = isset($_POST['csv_sql']) ? $_POST['csv_sql'] : ""; -
branches/version-2/data/class/pages/admin/mail/LC_Page_Admin_Mail.php
r18176 r18177 202 202 $this->list_data = $list_data; 203 203 $this->arrCampaignList = $this->lfGetCampaignList($objQuery); 204 204 205 205 $objView->assignobj($this); 206 206 $objView->display($tpl_path); … … 402 402 } 403 403 404 // 商品コードで検索された場合にヒットした 受注番号を取得する。404 // 商品コードで検索された場合にヒットした注文番号を取得する。 405 405 function lfGetCustomerOrderId($keyword) { 406 406 $arrCustomerOrderId = null; -
branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order.php
r18176 r18177 230 230 break; 231 231 case 'search_eorderyear': 232 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_eorderyear'], $_POST['search_eordermonth'], $_POST['search_eorderday'] );232 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_eorderyear'], $_POST['search_eordermonth'], $_POST['search_eorderday'], true); 233 233 $where.= " AND create_date <= ?"; 234 234 $arrval[] = $date; … … 371 371 /* パラメータ情報の初期化 */ 372 372 function lfInitParam() { 373 $this->objFormParam->addParam(" 受注番号1", "search_order_id1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));374 $this->objFormParam->addParam(" 受注番号2", "search_order_id2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));373 $this->objFormParam->addParam("注文番号1", "search_order_id1", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 374 $this->objFormParam->addParam("注文番号2", "search_order_id2", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 375 375 $this->objFormParam->addParam("対応状況", "search_order_status", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 376 376 $this->objFormParam->addParam("顧客名", "search_order_name", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); … … 413 413 414 414 // 特殊項目チェック 415 $objErr->doFunc(array(" 受注番号1", "受注番号2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK"));415 $objErr->doFunc(array("注文番号1", "注文番号2", "search_order_id1", "search_order_id2"), array("GREATER_CHECK")); 416 416 $objErr->doFunc(array("年齢1", "年齢2", "search_age1", "search_age2"), array("GREATER_CHECK")); 417 417 $objErr->doFunc(array("購入金額1", "購入金額2", "search_total1", "search_total2"), array("GREATER_CHECK")); -
branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php
r18176 r18177 88 88 /* ペイジェント決済モジュール連携用 */ 89 89 if(function_exists("sfPaygentOrderPage")) { 90 $this->arr FormKind = sfPaygentOrderPage();90 $this->arrDispKind = sfPaygentOrderPage(); 91 91 } 92 92 … … 372 372 // 受注商品情報 373 373 $this->objFormParam->addParam("値引き", "discount", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0'); 374 $this->objFormParam->addParam("送料", "deliv_fee", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK") );374 $this->objFormParam->addParam("送料", "deliv_fee", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0'); 375 375 $this->objFormParam->addParam("手数料", "charge", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); 376 376 … … 409 409 $this->objFormParam->addParam("顧客ID", "customer_id"); 410 410 $this->objFormParam->addParam("現在のポイント", "point"); 411 $this->objFormParam->addParam(" 受注番号", "order_id");411 $this->objFormParam->addParam("注文番号", "order_id"); 412 412 $this->objFormParam->addParam("受注日", "create_date"); 413 413 $this->objFormParam->addParam("発送日", "commit_date"); … … 441 441 $this->arrForm["payment_type"] = "お支払い"; 442 442 } 443 //受注データを表示用配列に代入（各EC-CUBEバージョンと決済モジュールとのデータ連携保全のため） 444 $this->arrDisp = $this->arrForm; 443 445 } 444 446 } … … 566 568 if ($sqlval['status'] == ODERSTATUS_COMMIT) { 567 569 // 受注テーブルの発送済み日を更新する 568 $sql .= " ,commit_date = 'NOW()'";570 $sql .= " ,commit_date = NOW()"; 569 571 } 570 572 $sql .= " WHERE order_id = ?"; … … 697 699 $arrProduct = $this->lfGetProductsClass($product_id, $classcategory_id1, $classcategory_id2); 698 700 $this->arrForm = $this->objFormParam->getFormParamList(); 699 $this->lfSetProductData($arrProduct); 701 $existes = false; 702 $existes_key = NULL; 703 // 既に同じ商品がないか、確認する 704 if (!empty($this->arrForm['product_id']['value'])) { 705 foreach ($this->arrForm['product_id']['value'] AS $key=>$val) { 706 if ($val == $product_id && $this->arrForm['product_id']['classcategory_id1'][$key] == $classcategory_id1 && $this->arrForm['product_id']['classcategory_id2'][$key] == $classcategory_id2) { 707 // 既に同じ商品がある 708 $existes = true; 709 $existes_key = $key; 710 } 711 } 712 } 713 714 if ($existes) { 715 // 既に同じ商品がある場合 716 ++$this->arrForm['quantity']['value'][$existes_key]; 717 } else { 718 // 既に同じ商品がない場合 719 $this->lfSetProductData($arrProduct); 720 } 700 721 } 701 722 -
branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order_Mail.php
r18176 r18177 168 168 $objFormParam->addParam("テンプレート", "template_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); 169 169 $objFormParam->addParam("メールタイトル", "subject", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK")); 170 $objFormParam->addParam("ヘッダー", "header", LTEXT_LEN, "KVa", array(" EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));171 $objFormParam->addParam("フッター", "footer", LTEXT_LEN, "KVa", array(" EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));170 $objFormParam->addParam("ヘッダー", "header", LTEXT_LEN, "KVa", array("MAX_LENGTH_CHECK", "SPTAB_CHECK")); 171 $objFormParam->addParam("フッター", "footer", LTEXT_LEN, "KVa", array("MAX_LENGTH_CHECK", "SPTAB_CHECK")); 172 172 } 173 173 } -
branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order_Pdf.php
r18176 r18177 127 127 $arrForm['msg3'] = 'ご確認いただきますよう、お願いいたします。'; 128 128 129 // 受注番号があったら、セットする129 // 注文番号があったら、セットする 130 130 if(SC_Utils_Ex::sfIsInt($_GET['order_id'])) { 131 131 $arrForm['order_id'][0] = $_GET['order_id']; … … 156 156 /* パラメータ情報の初期化 */ 157 157 function lfInitParam() { 158 $this->objFormParam->addParam(" 受注番号", "order_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));158 $this->objFormParam->addParam("注文番号", "order_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); 159 159 $this->objFormParam->addParam("発行日", "year", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); 160 160 $this->objFormParam->addParam("発行日", "month", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); -
branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_Product.php
r18176 r18177 450 450 // コピー商品の場合には規格もコピーする 451 451 if($_POST["copy_product_id"] != "" and SC_Utils_Ex::sfIsInt($_POST["copy_product_id"])){ 452 // dtb_products_class のカラムを取得 453 $dbFactory = SC_DB_DBFactory_Ex::getInstance(); 454 $arrColList = $dbFactory->sfGetColumnList("dtb_products_class", $objQuery); 455 $arrColList_tmp = array_flip($arrColList); 456 457 // コピーしない列 458 unset($arrColList[$arrColList_tmp["product_class_id"]]); //規格ID 459 unset($arrColList[$arrColList_tmp["product_id"]]); //商品ID 460 unset($arrColList[$arrColList_tmp["create_date"]]); 461 462 $col = SC_Utils_Ex::sfGetCommaList($arrColList); 463 464 $objQuery->query("INSERT INTO dtb_products_class (product_id, create_date, ". $col .") SELECT ?, now(), " . $col. " FROM dtb_products_class WHERE product_id = ? ORDER BY product_class_id", array($product_id, $_POST["copy_product_id"])); 465 466 } 467 452 453 if($this->tpl_nonclass) 454 { 455 //規格なしの場合、コピーは価格等の入力が発生しているため、その内容で追加登録を行う 456 $arrList['product_id'] = $product_id; 457 $this->lfCopyProductClass($arrList, $objQuery); 458 } 459 else 460 { 461 //規格がある場合のコピーは複製元の内容で追加登録を行う 462 // dtb_products_class のカラムを取得 463 $dbFactory = SC_DB_DBFactory_Ex::getInstance(); 464 $arrColList = $dbFactory->sfGetColumnList("dtb_products_class", $objQuery); 465 $arrColList_tmp = array_flip($arrColList); 466 467 // コピーしない列 468 unset($arrColList[$arrColList_tmp["product_class_id"]]); //規格ID 469 unset($arrColList[$arrColList_tmp["product_id"]]); //商品ID 470 unset($arrColList[$arrColList_tmp["create_date"]]); 471 472 $col = SC_Utils_Ex::sfGetCommaList($arrColList); 473 474 $objQuery->query("INSERT INTO dtb_products_class (product_id, create_date, ". $col .") SELECT ?, now(), " . $col. " FROM dtb_products_class WHERE product_id = ? ORDER BY product_class_id", array($product_id, $_POST["copy_product_id"])); 475 } 476 } 468 477 } else { 469 478 $product_id = $arrList['product_id']; … … 561 570 562 571 if($this->tpl_nonclass) { 563 $objErr->doFunc(array("商品コード", "product_code", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK","MAX_LENGTH_CHECK" ,"MAX_LENGTH_CHECK"));572 $objErr->doFunc(array("商品コード", "product_code", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK","MAX_LENGTH_CHECK")); 564 573 $objErr->doFunc(array("通常価格", "price01", PRICE_LEN), array("ZERO_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 565 574 $objErr->doFunc(array("商品価格", "price02", PRICE_LEN), array("EXIST_CHECK", "NUM_CHECK", "ZERO_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); … … 723 732 return $dist_name; 724 733 } 734 735 /** 736 * dtb_products_classの複製 737 * 複製後、価格や商品コードを更新する 738 * 739 * @param array $arrList 740 * @param array $objQuery 741 * @return bool 742 */ 743 function lfCopyProductClass($arrList,$objQuery) 744 { 745 // 複製元のdtb_products_classを取得（規格なしのため、1件のみの取得） 746 $col = "*"; 747 $table = "dtb_products_class"; 748 $where = "product_id = ?"; 749 $arrProductClass = $objQuery->select($col, $table, $where, array($arrList["copy_product_id"])); 750 751 //トランザクション開始 752 $objQuery->begin(); 753 $err_flag = false; 754 //非編集項目はコピー、編集項目は上書きして登録 755 foreach($arrProductClass as $records) 756 { 757 foreach($records as $key => $value) 758 { 759 if(isset($arrList[$key])) 760 { 761 $records[$key] = $arrList[$key]; 762 } 763 } 764 unset($records["product_class_id"]); 765 unset($records["update_date"]); 766 767 $records["create_date"] = "Now()"; 768 $objQuery->insert($table, $records); 769 //エラー発生時は中断 770 if($objQuery->isError()) 771 { 772 $err_flag = true; 773 continue; 774 } 775 } 776 //トランザクション終了 777 if($err_flag) 778 { 779 $objQuery->rollback(); 780 } 781 else 782 { 783 $objQuery->commit(); 784 } 785 return !$err_flag; 786 } 725 787 } 726 788 ?> -
branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_ReviewEdit.php
r18176 r18177 67 67 SC_Utils_Ex::sfIsSuccess($objSess); 68 68 69 // 検索ワードの引継ぎ69 // 検索ワードの引継ぎ 70 70 foreach ($_POST as $key => $val){ 71 71 if (ereg("^search_", $key)){ … … 74 74 } 75 75 76 //取得文字列の変換用カラム 77 $arrRegistColumn = array ( 78 array( "column" => "update_date"), 79 array( "column" => "status"), 80 array( "column" => "recommend_level"), 81 array( "column" => "title","convert" => "KVa"), 82 array( "column" => "comment","convert" => "KVa"), 83 array( "column" => "reviewer_name","convert" => "KVa"), 84 array( "column" => "reviewer_url","convert" => "KVa"), 85 array( "column" => "sex","convert" => "n") 86 87 ); 88 89 //レビューIDを渡す 90 $this->tpl_review_id = isset($_POST['review_id']) ? $_POST['review_id'] : ""; 91 //レビュー情報のカラムの取得 92 $this->arrReview = $this->lfGetReviewData($this->tpl_review_id); 93 //登録済みのステータスを渡す 94 $this->tpl_pre_status = $this->arrReview['status']; 95 //商品ごとのレビュー表示数取得 96 $count = $this->objQuery->count("dtb_review", "del_flg=0 AND status=1 AND product_id=?", array($this->arrReview['product_id'])); 97 //両方選択可能 76 // 両方選択可能 98 77 $this->tpl_status_change = true; 99 78 100 79 if (!isset($_POST['mode'])) $_POST['mode'] = ""; 101 switch($_POST['mode']) { 102 //登録 103 case 'complete': 104 //フォーム値の変換 105 $arrReview = $this->lfConvertParam($_POST, $arrRegistColumn); 106 $this->arrErr = $this->lfCheckError($arrReview); 107 //エラー無し 108 if (!$this->arrErr){ 109 //レビュー情報の編集登録 110 $this->lfRegistReviewData($arrReview, $arrRegistColumn); 111 $this->arrReview = $arrReview; 112 $this->tpl_onload = "confirm('登録が完了しました。');"; 113 } 114 break; 115 default: 116 break; 80 switch ($_POST['mode']) { 81 // 登録 82 case 'complete': 83 // 取得文字列の変換用カラム 84 $arrRegistColumn = array ( 85 array("column" => "status"), 86 array("column" => "recommend_level"), 87 array("column" => "title", "convert" => "KVa"), 88 array("column" => "comment", "convert" => "KVa"), 89 array("column" => "reviewer_name", "convert" => "KVa"), 90 array("column" => "reviewer_url", "convert" => "KVa"), 91 array("column" => "sex", "convert" => "n") 92 ); 93 94 // フォーム値の変換 95 $arrReview = $this->lfConvertParam($_POST, $arrRegistColumn); 96 $this->arrErr = $this->lfCheckError($arrReview); 97 98 // エラー有り 99 if ($this->arrErr) { 100 // 入力内容を引き継ぐ 101 $this->arrReview = $arrReview; 102 } 103 // エラー無し 104 else { 105 // レビュー情報の更新 106 $this->lfRegistReviewData($arrReview, $arrRegistColumn); 107 108 // レビュー情報のDB取得 109 $this->arrReview = $this->lfGetReviewData($arrReview['review_id']); 110 111 $this->tpl_onload = "alert('登録が完了しました。');"; 112 } 113 break; 114 115 default: 116 // レビュー情報のDB取得 117 $this->arrReview = $this->lfGetReviewData($_POST['review_id']); 118 break; 117 119 } 118 120 … … 130 132 } 131 133 132 133 // 入力エラーチェック 134 function lfCheckError($array) { 135 $objErr = new SC_CheckError($array); 134 /** 135 * 入力エラーチェック 136 * 137 */ 138 function lfCheckError($arrReview) { 139 $objErr = new SC_CheckError($arrReview); 136 140 $objErr->doFunc(array("おすすめレベル", "recommend_level"), array("SELECT_CHECK")); 137 141 $objErr->doFunc(array("タイトル", "title", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); … … 143 147 } 144 148 145 //---- 取得文字列の変換 149 /** 150 * 取得文字列の変換 151 * 152 */ 146 153 function lfConvertParam($array, $arrRegistColumn) { 147 154 /* … … 169 176 } 170 177 171 //レビュー情報の取得 178 /** 179 * レビュー情報のDB取得 180 * 181 */ 172 182 function lfGetReviewData($review_id){ 173 183 $select="review_id, A.product_id, reviewer_name, sex, recommend_level, "; … … 176 186 $where = "A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? "; 177 187 $arrReview = $this->objQuery->select($select, $from, $where, array($review_id)); 178 if(!empty($arrReview)) { 179 $this->arrReview = $arrReview[0]; 180 } else { 188 if (empty($arrReview)) { 181 189 SC_Utils_Ex::sfDispError(""); 182 190 } 183 return $this->arrReview; 184 } 185 186 //レビュー情報の編集登録 187 function lfRegistReviewData($array, $arrRegistColumn){ 191 192 return $arrReview[0]; 193 } 194 195 /** 196 * レビュー情報の更新 197 * 198 */ 199 function lfRegistReviewData($arrReview, $arrRegistColumn){ 188 200 foreach ($arrRegistColumn as $data) { 189 if (strlen($array[ $data["column"] ]) > 0 ) { 190 $arrRegist[ $data["column"] ] = $array[ $data["column"] ]; 191 } 192 if ($data['column'] == 'update_date'){ 193 $arrRegist['update_date'] = 'now()'; 194 } 195 } 196 //登録実行 197 $this->objQuery->begin(); 198 $this->objQuery->update("dtb_review", $arrRegist, "review_id='".$_POST['review_id']."'"); 199 $this->objQuery->commit(); 201 $arrRegist[ $data["column"] ] = $arrReview[ $data["column"] ]; 202 } 203 $arrRegist['update_date'] = 'now()'; 204 205 // 更新実行 206 $this->objQuery->update("dtb_review", $arrRegist, "review_id = ?", array($arrReview['review_id'])); 200 207 } 201 208 } -
branches/version-2/data/class/pages/admin/products/LC_Page_Admin_Products_Trackback.php
r18176 r18177 169 169 case 'search_startyear': 170 170 if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) { 171 $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);171 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']); 172 172 $where.= " AND A.create_date >= ? "; 173 173 $arrval[] = $date; … … 177 177 case 'search_endyear': 178 178 if (isset($_POST['search_startyear']) && isset($_POST['search_startmonth']) && isset($_POST['search_startday'])) { 179 $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);179 $date = SC_Utils_Ex::sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']); 180 180 181 181 $end_date = date("Y/m/d",strtotime("1 day" ,strtotime($date)));
Note: See TracChangeset
for help on using the changeset viewer.
