Changeset 21526 for branches/version-2_12-dev/data/class/pages/admin/order
- Timestamp:
- 2012/02/17 00:50:05 (14 years ago)
- Location:
- branches/version-2_12-dev/data/class/pages/admin/order
- Files:
-
- 2 edited
-
LC_Page_Admin_Order.php (modified) (2 diffs)
-
LC_Page_Admin_Order_Edit.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/order/LC_Page_Admin_Order.php
r21515 r21526 99 99 100 100 switch ($this->getMode()) { 101 // 削除 102 case 'delete': 103 $this->doDelete('order_id = ?', 104 array($objFormParam->getValue('order_id'))); 105 // 削除後に検索結果を表示するため breakしない 106 107 // 検索パラメーター生成後に処理実行するため breakしない 108 case 'csv': 109 case 'delete_all': 110 111 // 検索パラメーターの生成 112 case 'search': 113 $objFormParam->convParam(); 114 $objFormParam->trimParam(); 115 $this->arrErr = $this->lfCheckError($objFormParam); 116 $arrParam = $objFormParam->getHashArray(); 117 118 if (count($this->arrErr) == 0) { 119 $where = 'del_flg = 0'; 120 foreach ($arrParam as $key => $val) { 121 if ($val == '') { 122 continue; 101 // 削除 102 case 'delete': 103 $this->doDelete('order_id = ?', 104 array($objFormParam->getValue('order_id'))); 105 // 削除後に検索結果を表示するため breakしない 106 107 // 検索パラメーター生成後に処理実行するため breakしない 108 case 'csv': 109 case 'delete_all': 110 111 // 検索パラメーターの生成 112 case 'search': 113 $objFormParam->convParam(); 114 $objFormParam->trimParam(); 115 $this->arrErr = $this->lfCheckError($objFormParam); 116 $arrParam = $objFormParam->getHashArray(); 117 118 if (count($this->arrErr) == 0) { 119 $where = 'del_flg = 0'; 120 foreach ($arrParam as $key => $val) { 121 if ($val == '') { 122 continue; 123 } 124 $this->buildQuery($key, $where, $arrval, $objFormParam); 123 125 } 124 $this->buildQuery($key, $where, $arrval, $objFormParam); 126 127 $order = 'update_date DESC'; 128 129 /* ----------------------------------------------- 130 * 処理を実行 131 * ----------------------------------------------- */ 132 switch ($this->getMode()) { 133 // CSVを送信する。 134 case 'csv': 135 $this->doOutputCSV($where, $arrval,$order); 136 exit; 137 break; 138 139 // 全件削除(ADMIN_MODE) 140 case 'delete_all': 141 $this->doDelete($where, $arrval); 142 break; 143 144 // 検索実行 145 default: 146 // 行数の取得 147 $this->tpl_linemax = $this->getNumberOfLines($where, $arrval); 148 // ページ送りの処理 149 $page_max = SC_Utils_Ex::sfGetSearchPageMax($objFormParam->getValue('search_page_max')); 150 // ページ送りの取得 151 $objNavi = new SC_PageNavi_Ex($this->arrHidden['search_pageno'], 152 $this->tpl_linemax, $page_max, 153 'fnNaviSearchPage', NAVI_PMAX); 154 $this->arrPagenavi = $objNavi->arrPagenavi; 155 156 // 検索結果の取得 157 $this->arrResults = $this->findOrders($where, $arrval, 158 $page_max, $objNavi->start_row, $order); 159 break; 160 } 125 161 } 126 127 $order = 'update_date DESC'; 128 129 /* ----------------------------------------------- 130 * 処理を実行 131 * ----------------------------------------------- */ 132 switch ($this->getMode()) { 133 // CSVを送信する。 134 case 'csv': 135 $this->doOutputCSV($where, $arrval,$order); 136 exit; 137 break; 138 139 // 全件削除(ADMIN_MODE) 140 case 'delete_all': 141 $this->doDelete($where, $arrval); 142 break; 143 144 // 検索実行 145 default: 146 // 行数の取得 147 $this->tpl_linemax = $this->getNumberOfLines($where, $arrval); 148 // ページ送りの処理 149 $page_max = SC_Utils_Ex::sfGetSearchPageMax($objFormParam->getValue('search_page_max')); 150 // ページ送りの取得 151 $objNavi = new SC_PageNavi_Ex($this->arrHidden['search_pageno'], 152 $this->tpl_linemax, $page_max, 153 'fnNaviSearchPage', NAVI_PMAX); 154 $this->arrPagenavi = $objNavi->arrPagenavi; 155 156 // 検索結果の取得 157 $this->arrResults = $this->findOrders($where, $arrval, 158 $page_max, $objNavi->start_row, $order); 159 } 160 } 161 break; 162 default: 162 break; 163 default: 164 break; 163 165 } 164 166 } … … 268 270 switch ($key) { 269 271 270 case 'search_product_name': 271 $where .= ' AND EXISTS (SELECT 1 FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?)'; 272 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 273 break; 274 case 'search_order_name': 275 $where .= ' AND ' . $dbFactory->concatColumn(array('order_name01', 'order_name02')) . ' LIKE ?'; 276 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 277 break; 278 case 'search_order_kana': 279 $where .= ' AND ' . $dbFactory->concatColumn(array('order_kana01', 'order_kana02')) . ' LIKE ?'; 280 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 281 break; 282 case 'search_order_id1': 283 $where .= ' AND order_id >= ?'; 284 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 285 break; 286 case 'search_order_id2': 287 $where .= ' AND order_id <= ?'; 288 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 289 break; 290 case 'search_order_sex': 291 $tmp_where = ''; 292 foreach ($objFormParam->getValue($key) as $element) { 293 if ($element != '') { 294 if (SC_Utils_Ex::isBlank($tmp_where)) { 295 $tmp_where .= ' AND (order_sex = ?'; 296 } else { 297 $tmp_where .= ' OR order_sex = ?'; 272 case 'search_product_name': 273 $where .= ' AND EXISTS (SELECT 1 FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?)'; 274 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 275 break; 276 case 'search_order_name': 277 $where .= ' AND ' . $dbFactory->concatColumn(array('order_name01', 'order_name02')) . ' LIKE ?'; 278 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 279 break; 280 case 'search_order_kana': 281 $where .= ' AND ' . $dbFactory->concatColumn(array('order_kana01', 'order_kana02')) . ' LIKE ?'; 282 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 283 break; 284 case 'search_order_id1': 285 $where .= ' AND order_id >= ?'; 286 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 287 break; 288 case 'search_order_id2': 289 $where .= ' AND order_id <= ?'; 290 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 291 break; 292 case 'search_order_sex': 293 $tmp_where = ''; 294 foreach ($objFormParam->getValue($key) as $element) { 295 if ($element != '') { 296 if (SC_Utils_Ex::isBlank($tmp_where)) { 297 $tmp_where .= ' AND (order_sex = ?'; 298 } else { 299 $tmp_where .= ' OR order_sex = ?'; 300 } 301 $arrValues[] = $element; 298 302 } 299 $arrValues[] = $element;300 303 } 301 } 302 303 if (!SC_Utils_Ex::isBlank($tmp_where)) { 304 $tmp_where .= ')'; 305 $where .= " $tmp_where "; 306 } 307 break; 308 case 'search_order_tel': 309 $where .= ' AND (' . $dbFactory->concatColumn(array('order_tel01', 'order_tel02', 'order_tel03')) . ' LIKE ?)'; 310 $arrValues[] = sprintf('%%%d%%', preg_replace('/[()-]+/','', $objFormParam->getValue($key))); 311 break; 312 case 'search_order_email': 313 $where .= ' AND order_email LIKE ?'; 314 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 315 break; 316 case 'search_payment_id': 317 $tmp_where = ''; 318 foreach ($objFormParam->getValue($key) as $element) { 319 if ($element != '') { 320 if ($tmp_where == '') { 321 $tmp_where .= ' AND (payment_id = ?'; 322 } else { 323 $tmp_where .= ' OR payment_id = ?'; 304 305 if (!SC_Utils_Ex::isBlank($tmp_where)) { 306 $tmp_where .= ')'; 307 $where .= " $tmp_where "; 308 } 309 break; 310 case 'search_order_tel': 311 $where .= ' AND (' . $dbFactory->concatColumn(array('order_tel01', 'order_tel02', 'order_tel03')) . ' LIKE ?)'; 312 $arrValues[] = sprintf('%%%d%%', preg_replace('/[()-]+/','', $objFormParam->getValue($key))); 313 break; 314 case 'search_order_email': 315 $where .= ' AND order_email LIKE ?'; 316 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 317 break; 318 case 'search_payment_id': 319 $tmp_where = ''; 320 foreach ($objFormParam->getValue($key) as $element) { 321 if ($element != '') { 322 if ($tmp_where == '') { 323 $tmp_where .= ' AND (payment_id = ?'; 324 } else { 325 $tmp_where .= ' OR payment_id = ?'; 326 } 327 $arrValues[] = $element; 324 328 } 325 $arrValues[] = $element;326 329 } 327 } 328 329 if (!SC_Utils_Ex::isBlank($tmp_where)) {330 $tmp_where .= ')';331 $where .= " $tmp_where ";332 }333 break;334 case 'search_total1':335 $where .= ' AND total >= ?';336 $arrValues[] = sprintf('%d', $objFormParam->getValue($key));337 break;338 case 'search_total2':339 $where .= ' AND total <= ?';340 $arrValues[] = sprintf('%d', $objFormParam->getValue($key));341 break;342 case 'search_sorderyear':343 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_sorderyear'),344 $objFormParam->getValue('search_sordermonth'),345 $objFormParam->getValue('search_sorderday'));346 $where.= ' AND create_date >= ?';347 $arrValues[] = $date;348 break;349 case 'search_eorderyear':350 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_eorderyear'),351 $objFormParam->getValue('search_eordermonth'),352 $objFormParam->getValue('search_eorderday'), true);353 $where.= ' AND create_date <= ?';354 $arrValues[] = $date;355 break;356 case 'search_supdateyear':357 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_supdateyear'),358 $objFormParam->getValue('search_supdatemonth'),359 $objFormParam->getValue('search_supdateday'));360 $where.= ' AND update_date >= ?';361 $arrValues[] = $date;362 break;363 case 'search_eupdateyear':364 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_eupdateyear'),365 $objFormParam->getValue('search_eupdatemonth'),366 $objFormParam->getValue('search_eupdateday'), true);367 $where.= ' AND update_date <= ?';368 $arrValues[] = $date;369 break;370 case 'search_sbirthyear':371 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_sbirthyear'),372 $objFormParam->getValue('search_sbirthmonth'),373 $objFormParam->getValue('search_sbirthday'));374 $where.= ' AND order_birth >= ?';375 $arrValues[] = $date;376 break;377 case 'search_ebirthyear':378 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_ebirthyear'),379 $objFormParam->getValue('search_ebirthmonth'),380 $objFormParam->getValue('search_ebirthday'), true);381 $where.= ' AND order_birth <= ?';382 $arrValues[] = $date;383 break;384 case 'search_order_status':385 $where.= ' AND status = ?';386 $arrValues[] = $objFormParam->getValue($key);387 break;388 default:330 331 if (!SC_Utils_Ex::isBlank($tmp_where)) { 332 $tmp_where .= ')'; 333 $where .= " $tmp_where "; 334 } 335 break; 336 case 'search_total1': 337 $where .= ' AND total >= ?'; 338 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 339 break; 340 case 'search_total2': 341 $where .= ' AND total <= ?'; 342 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 343 break; 344 case 'search_sorderyear': 345 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_sorderyear'), 346 $objFormParam->getValue('search_sordermonth'), 347 $objFormParam->getValue('search_sorderday')); 348 $where.= ' AND create_date >= ?'; 349 $arrValues[] = $date; 350 break; 351 case 'search_eorderyear': 352 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_eorderyear'), 353 $objFormParam->getValue('search_eordermonth'), 354 $objFormParam->getValue('search_eorderday'), true); 355 $where.= ' AND create_date <= ?'; 356 $arrValues[] = $date; 357 break; 358 case 'search_supdateyear': 359 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_supdateyear'), 360 $objFormParam->getValue('search_supdatemonth'), 361 $objFormParam->getValue('search_supdateday')); 362 $where.= ' AND update_date >= ?'; 363 $arrValues[] = $date; 364 break; 365 case 'search_eupdateyear': 366 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_eupdateyear'), 367 $objFormParam->getValue('search_eupdatemonth'), 368 $objFormParam->getValue('search_eupdateday'), true); 369 $where.= ' AND update_date <= ?'; 370 $arrValues[] = $date; 371 break; 372 case 'search_sbirthyear': 373 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_sbirthyear'), 374 $objFormParam->getValue('search_sbirthmonth'), 375 $objFormParam->getValue('search_sbirthday')); 376 $where.= ' AND order_birth >= ?'; 377 $arrValues[] = $date; 378 break; 379 case 'search_ebirthyear': 380 $date = SC_Utils_Ex::sfGetTimestamp($objFormParam->getValue('search_ebirthyear'), 381 $objFormParam->getValue('search_ebirthmonth'), 382 $objFormParam->getValue('search_ebirthday'), true); 383 $where.= ' AND order_birth <= ?'; 384 $arrValues[] = $date; 385 break; 386 case 'search_order_status': 387 $where.= ' AND status = ?'; 388 $arrValues[] = $objFormParam->getValue($key); 389 break; 390 default: 391 break; 389 392 } 390 393 } -
branches/version-2_12-dev/data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php
r21515 r21526 153 153 154 154 switch ($this->getMode()) { 155 case 'pre_edit': 156 case 'order_id': 157 break; 158 159 case 'edit': 160 $objFormParam->setParam($_POST); 161 $objFormParam->convParam(); 162 $this->arrErr = $this->lfCheckError($objFormParam); 163 if (SC_Utils_Ex::isBlank($this->arrErr)) { 164 $message = '受注を編集しました。'; 165 $order_id = $this->doRegister($order_id, $objPurchase, $objFormParam, $message, $arrValuesBefore); 166 if ($order_id >= 0) { 167 $this->setOrderToFormParam($objFormParam, $order_id); 168 } 169 $this->tpl_onload = "window.alert('" . $message . "');"; 170 } 171 break; 172 173 case 'add': 174 if ($_SERVER['REQUEST_METHOD'] == 'POST') { 155 case 'pre_edit': 156 case 'order_id': 157 break; 158 159 case 'edit': 175 160 $objFormParam->setParam($_POST); 176 161 $objFormParam->convParam(); 177 162 $this->arrErr = $this->lfCheckError($objFormParam); 178 163 if (SC_Utils_Ex::isBlank($this->arrErr)) { 179 $message = '受注を 登録しました。';180 $order_id = $this->doRegister( null, $objPurchase, $objFormParam, $message, $arrValuesBefore);164 $message = '受注を編集しました。'; 165 $order_id = $this->doRegister($order_id, $objPurchase, $objFormParam, $message, $arrValuesBefore); 181 166 if ($order_id >= 0) { 182 $this->tpl_mode = 'edit';183 $objFormParam->setValue('order_id', $order_id);184 167 $this->setOrderToFormParam($objFormParam, $order_id); 185 168 } 186 169 $this->tpl_onload = "window.alert('" . $message . "');"; 187 170 } 188 } 189 190 break; 191 192 // 再計算 193 case 'recalculate': 194 //支払い方法の選択 195 case 'payment': 196 // 配送業者の選択 197 case 'deliv': 198 $objFormParam->setParam($_POST); 199 $objFormParam->convParam(); 200 $this->arrErr = $this->lfCheckError($objFormParam); 201 break; 202 203 // 商品削除 204 case 'delete_product': 205 $objFormParam->setParam($_POST); 206 $objFormParam->convParam(); 207 $delete_no = $objFormParam->getValue('delete_no'); 208 $this->doDeleteProduct($delete_no, $objFormParam); 209 $this->arrErr = $this->lfCheckError($objFormParam); 210 break; 211 212 // 商品追加ポップアップより商品選択 213 case 'select_product_detail': 214 $objFormParam->setParam($_POST); 215 $objFormParam->convParam(); 216 $this->doRegisterProduct($objFormParam); 217 $this->arrErr = $this->lfCheckError($objFormParam); 218 break; 219 220 // 会員検索ポップアップより会員指定 221 case 'search_customer': 222 $objFormParam->setParam($_POST); 223 $objFormParam->convParam(); 224 $this->setCustomerTo($objFormParam->getValue('edit_customer_id'), 225 $objFormParam); 226 $this->arrErr = $this->lfCheckError($objFormParam); 227 break; 228 229 // 複数配送設定表示 230 case 'multiple': 231 $objFormParam->setParam($_POST); 232 $objFormParam->convParam(); 233 $this->arrErr = $this->lfCheckError($objFormParam); 234 break; 235 236 // 複数配送設定を反映 237 case 'multiple_set_to': 238 $this->lfInitMultipleParam($objFormParam); 239 $objFormParam->setParam($_POST); 240 $objFormParam->convParam(); 241 $this->setMultipleItemTo($objFormParam); 242 break; 243 244 // お届け先の追加 245 case 'append_shipping': 246 $objFormParam->setParam($_POST); 247 $objFormParam->convParam(); 248 $this->addShipping($objFormParam); 249 break; 250 251 default: 171 break; 172 173 case 'add': 174 if ($_SERVER['REQUEST_METHOD'] == 'POST') { 175 $objFormParam->setParam($_POST); 176 $objFormParam->convParam(); 177 $this->arrErr = $this->lfCheckError($objFormParam); 178 if (SC_Utils_Ex::isBlank($this->arrErr)) { 179 $message = '受注を登録しました。'; 180 $order_id = $this->doRegister(null, $objPurchase, $objFormParam, $message, $arrValuesBefore); 181 if ($order_id >= 0) { 182 $this->tpl_mode = 'edit'; 183 $objFormParam->setValue('order_id', $order_id); 184 $this->setOrderToFormParam($objFormParam, $order_id); 185 } 186 $this->tpl_onload = "window.alert('" . $message . "');"; 187 } 188 } 189 190 break; 191 192 // 再計算 193 case 'recalculate': 194 //支払い方法の選択 195 case 'payment': 196 // 配送業者の選択 197 case 'deliv': 198 $objFormParam->setParam($_POST); 199 $objFormParam->convParam(); 200 $this->arrErr = $this->lfCheckError($objFormParam); 201 break; 202 203 // 商品削除 204 case 'delete_product': 205 $objFormParam->setParam($_POST); 206 $objFormParam->convParam(); 207 $delete_no = $objFormParam->getValue('delete_no'); 208 $this->doDeleteProduct($delete_no, $objFormParam); 209 $this->arrErr = $this->lfCheckError($objFormParam); 210 break; 211 212 // 商品追加ポップアップより商品選択 213 case 'select_product_detail': 214 $objFormParam->setParam($_POST); 215 $objFormParam->convParam(); 216 $this->doRegisterProduct($objFormParam); 217 $this->arrErr = $this->lfCheckError($objFormParam); 218 break; 219 220 // 会員検索ポップアップより会員指定 221 case 'search_customer': 222 $objFormParam->setParam($_POST); 223 $objFormParam->convParam(); 224 $this->setCustomerTo($objFormParam->getValue('edit_customer_id'), 225 $objFormParam); 226 $this->arrErr = $this->lfCheckError($objFormParam); 227 break; 228 229 // 複数配送設定表示 230 case 'multiple': 231 $objFormParam->setParam($_POST); 232 $objFormParam->convParam(); 233 $this->arrErr = $this->lfCheckError($objFormParam); 234 break; 235 236 // 複数配送設定を反映 237 case 'multiple_set_to': 238 $this->lfInitMultipleParam($objFormParam); 239 $objFormParam->setParam($_POST); 240 $objFormParam->convParam(); 241 $this->setMultipleItemTo($objFormParam); 242 break; 243 244 // お届け先の追加 245 case 'append_shipping': 246 $objFormParam->setParam($_POST); 247 $objFormParam->convParam(); 248 $this->addShipping($objFormParam); 249 break; 250 251 default: 252 break; 252 253 } 253 254
Note: See TracChangeset
for help on using the changeset viewer.
