public function getcodelistAction() { $data = array(); $code = new Product_Model_Materiel(); echo Zend_Json::encode($code->getOptionList()); exit; }
public function importitemsAction() { $result = array('success' => true, 'data' => array(), 'info' => '导入成功'); if (isset($_FILES['csv'])) { $file = $_FILES['csv']; $file_extension = strrchr($file['name'], "."); $h = new Application_Model_Helpers(); $tmp_file_name = $h->getMicrotimeStr() . $file_extension; $savepath = "../temp/"; $tmp_file_path = $savepath . $tmp_file_name; move_uploaded_file($file["tmp_name"], $tmp_file_path); $file = fopen($tmp_file_path, "r"); $i = 0; $materiel = new Product_Model_Materiel(); $desc = new Product_Model_Desc(); while (!feof($file)) { $csv_data = fgetcsv($file); $code = isset($csv_data[1]) ? $csv_data[1] : ''; $qty = isset($csv_data[2]) ? $csv_data[2] : 0; $date_req = isset($csv_data[3]) ? str_replace('-', '/', $csv_data[3]) : ''; $project_info = isset($csv_data[4]) ? $csv_data[4] : ''; $order_req_num = isset($csv_data[5]) ? $csv_data[5] : ''; $customer_address = isset($csv_data[6]) ? $csv_data[6] : ''; $customer_aggrement = isset($csv_data[7]) ? $csv_data[7] : ''; $remark = isset($csv_data[8]) ? $csv_data[8] : ''; if ($i > 0 && $code != '') { $materielData = $materiel->getOptionList($code); $is_changing = false; if ($code != '') { $is_changing = $desc->isChanging($code); } if (count($materielData) > 0) { array_push($result['data'], array('code' => $code, 'is_changing' => $is_changing, 'name' => $materielData['name'], 'description' => $materielData['description'], 'unit' => $materielData['unit'], 'qty' => $qty, 'date_req' => $date_req, 'project_info' => mb_convert_encoding($project_info, 'UTF-8', 'GBK'), 'order_req_num' => $order_req_num, 'customer_address' => $customer_address, 'customer_aggrement' => $customer_aggrement, 'remark' => mb_convert_encoding($remark, 'UTF-8', 'GBK'))); } else { $result['success'] = 0; $result['info'] = $code . '未找到,导入失败!'; echo Zend_Json::encode($result); exit; } } $i++; } fclose($file); } else { $result['success'] = false; $result['info'] = '没有选择文件,导入失败!'; } //echo '<pre>';print_r($result);die; echo Zend_Json::encode($result); exit; }
public function importitemsAction() { $result = array('success' => true, 'data' => array(), 'info' => '导入成功'); $request = $this->getRequest()->getParams(); $type = isset($request['type']) ? $request['type'] : null; if ($type && isset($_FILES['csv'])) { $file = $_FILES['csv']; $file_extension = strrchr($file['name'], "."); $h = new Application_Model_Helpers(); $tmp_file_name = $h->getMicrotimeStr() . $file_extension; $savepath = "../temp/"; $tmp_file_path = $savepath . $tmp_file_name; move_uploaded_file($file["tmp_name"], $tmp_file_path); $file = fopen($tmp_file_path, "r"); $i = 0; $materiel = new Product_Model_Materiel(); $stock = new Erp_Model_Stock_Stock(); while (!feof($file)) { $csv_data = fgetcsv($file); $code = isset($csv_data[1]) ? $csv_data[1] : ''; $qty = isset($csv_data[2]) ? $csv_data[2] : 0; $warehouse_code = 0; $warehouse_code_transfer = 0; if ($type == 'in') { $warehouse_code = isset($csv_data[4]) ? $csv_data[4] : ''; } else { if ($type == 'out') { $warehouse_code = isset($csv_data[3]) ? $csv_data[3] : ''; } else { if ($type == 'transfer') { $warehouse_code = isset($csv_data[3]) ? $csv_data[3] : ''; $warehouse_code_transfer = isset($csv_data[4]) ? $csv_data[4] : ''; } } } $remark = isset($csv_data[5]) ? $csv_data[5] : ''; if ($i > 0 && $code != '') { $materielData = $materiel->getOptionList($code); if (count($materielData) > 0) { // 获取仓位剩余库存 $warehouse = array(); array_push($warehouse, $warehouse_code); $warehouse_qty = $stock->getStockQty($code, $warehouse); array_push($result['data'], array('code' => $code, 'name' => $materielData['name'], 'description' => $materielData['description'], 'unit' => $materielData['unit'], 'qty' => $qty, 'warehouse_qty' => $warehouse_qty['total'], 'warehouse_code' => $warehouse_code, 'warehouse_code_transfer' => $warehouse_code_transfer, 'remark' => $remark)); } else { echo Zend_Json::encode(array('success' => false, 'info' => '物料号 [' . $code . '] 错误,导入失败!')); exit; } } $i++; } fclose($file); } else { $result['success'] = false; $result['info'] = '没有选择文件,导入失败!'; } /* echo '<pre>'; print_r($result); exit; */ echo Zend_Json::encode($result); exit; }