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;
}
