/**
* @abstract 取得供应商信息
* @return 供应商代码+供应商名称
*/
public function getsupplyAction()
{
$result = $this->getRequest()->getParams();
$bpartner = new Product_Model_Bpartner();
if (isset($result['q']) && $result['q']) {
$query = $result['q'];
$where = "code like '%{$query}%' or cname like '%{$query}%' or ename like '%{$query}%'";
} else {
$where = "1=1";
}
$data = $bpartner->getListForSel($where);
$result = array();
for ($i = 0; $i < count($data); $i++) {
if (($code = $data[$i]['code']) != '') {
$result[$i] = array();
$result[$i]['supply_code'] = $code;
if (($cname = $data[$i]['cname']) != '') {
$result[$i]['supply_name'] = $cname;
} else {
if (($ename = $data[$i]['ename']) != '') {
$result[$i]['supply_name'] = $ename;
} else {
$result[$i]['supply_name'] = '';
}
}
$result[$i]['supply'] = $result[$i]['supply_code'] . $result[$i]['supply_name'];
$result[$i]['currency'] = $data[$i]['bank_currency'];
}
}
// 转为json格式并输出
echo Zend_Json::encode($result);
exit;
}
public function getlistAction()
{
$request = $this->getRequest()->getParams();
$limit = $request['limit'];
$start = $request['start'];
$desc = new Product_Model_Desc();
$descName = $desc->getName();
$whereSearch = "1=1";
$mytype = $this->getRequest()->getParam('mytype');
if ($mytype == 3) {
$whereSearch = "{$descName}.state = 'Reviewing'";
}
foreach ($request as $k => $v) {
if ($v) {
if ($k == 'search_tag') {
$whereSearch .= " and (ifnull({$descName}.remark,'') like '%{$v}%' or ifnull({$descName}.manufacturers_before,'') like '%{$v}%' or ifnull({$descName}.manufacturers_after,'') like '%{$v}%' or ifnull({$descName}.desc_before,'') like '%{$v}%' or ifnull({$descName}.desc_after,'') like '%{$v}%')";
} else {
$col = str_replace('search_', '', $k);
if ($col != $k) {
// 查询条件
$whereSearch .= " and ifnull({$descName}." . $col . ",'') like '%" . $v . "%'";
}
}
}
}
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$materiel = new Product_Model_Materiel();
$type = new Product_Model_Type();
$record = new Dcc_Model_Record();
$flow = new Admin_Model_Flow();
$step = new Admin_Model_Step();
$review = new Dcc_Model_Review();
$employee = new Hra_Model_Employee();
// 查询条件
// 供应商
$supply = new Product_Model_Bpartner();
$supplyData = $supply->getJoinList(array(), array(), array('id', 'code', 'cname', 'ename'));
// 审核中
$reviewingData = $review->getJoinList("finish_flg = 0 and type = 'materiel_desc' and (actual_user is null or !(FIND_IN_SET({$user},actual_user))) and (FIND_IN_SET({$user}, plan_user))", array(), array('table_id'));
$reviewingIds = array();
foreach ($reviewingData as $r) {
if (!in_array($r['id'], $reviewingIds)) {
$reviewingIds[] = $r['id'];
}
}
// 审核过
$reviewedData = $review->getJoinList("finish_flg = 1 and type = 'materiel_desc' and (FIND_IN_SET({$user},actual_user))", array(), array('table_id'));
$reviewedIds = array();
foreach ($reviewedData as $r) {
if (!in_array($r['id'], $reviewedIds)) {
$reviewedIds[] = $r['id'];
}
}
$join = array(array('type' => INNERJOIN, 'table' => $employee->getName(), 'condition' => $employee->getName() . '.id = ' . $desc->getName() . '.create_user'));
$myType = "";
if (isset($request['mytype'])) {
$myType = $request['mytype'];
}
if ($myType == 1) {
$whereSearch .= " and {$descName}.create_user = {$user}";
} else {
if ($myType == 2 && count($reviewedIds) > 0) {
$whereSearch .= " and {$descName}.id in (" . implode(',', $reviewedIds) . ")";
} else {
if ($myType == 3 && count($reviewingIds) > 0) {
$whereSearch .= " and {$descName}.id in (" . implode(',', $reviewingIds) . ")";
} else {
// $whereSearch .= " and ($descName.create_user = $user ";
$whereSearch .= " and (1=1 ";
if (count($reviewedIds) > 0) {
$whereSearch .= " or {$descName}.id in (" . implode(',', $reviewedIds) . ")";
}
if (count($reviewingIds) > 0) {
$whereSearch .= " or {$descName}.id in (" . implode(',', $reviewingIds) . ")";
}
$whereSearch .= ")";
}
}
}
$total = $desc->getJoinCount($whereSearch);
if ($total > 0) {
$join = array(array('type' => INNERJOIN, 'table' => $employee->getName(), 'condition' => $employee->getName() . '.id = ' . $desc->getName() . '.create_user', 'cols' => array('creater' => 'cname')));
$data = $desc->getJoinList($whereSearch, $join, null, array($desc->getName() . '.state desc', $desc->getName() . '.create_time desc'), $start, $limit);
} else {
$data = array();
}
$fileIds = array();
// 获取物料数据
for ($i = 0; $i < count($data); $i++) {
$mytype = 2;
if ($data[$i]['create_user'] == $user) {
$mytype = 1;
}
if (($typeId = $data[$i]['type_before']) != '') {
$typeName = $type->getTypeByConnect($typeId, '');
$data[$i]['type_name'] = $typeName;
}
$data[$i]['create_time'] = strtotime($data[$i]['create_time']);
$data[$i]['archive_time'] = strtotime($data[$i]['archive_time']);
// files
if ($data[$i]['data_file_id_before'] && !in_array($data[$i]['data_file_id_before'], $fileIds)) {
$fileIds[] = $data[$i]['data_file_id_before'];
}
if ($data[$i]['data_file_id_after'] && !in_array($data[$i]['data_file_id_after'], $fileIds)) {
$fileIds[] = $data[$i]['data_file_id_after'];
}
if ($data[$i]['tsr_id_before'] && !in_array($data[$i]['tsr_id_before'], $fileIds)) {
$fileIds[] = $data[$i]['tsr_id_before'];
}
if ($data[$i]['tsr_id_after'] && !in_array($data[$i]['tsr_id_after'], $fileIds)) {
$fileIds[] = $data[$i]['tsr_id_after'];
}
if ($data[$i]['first_report_id_before'] && !in_array($data[$i]['first_report_id_before'], $fileIds)) {
$fileIds[] = $data[$i]['first_report_id_before'];
}
if ($data[$i]['first_report_id_after'] && !in_array($data[$i]['first_report_id_after'], $fileIds)) {
$fileIds[] = $data[$i]['first_report_id_after'];
}
// 增加审核状态
$reviewState = "";
$step_name = "";
if ($data[$i]['state'] == 'Active') {
$reviewState = "已归档";
} else {
if ($data[$i]['state'] == 'Reviewing') {
// 查询当前审核状态
// 查询所有审核阶段
$reviewRows = $review->getList("file_id = " . $data[$i]['id'], "materiel_desc");
if (count($reviewRows) > 0) {
$first = true;
foreach ($reviewRows as $row) {
if ($row['finish_flg'] == 1) {
if ($step_name) {
$step_name .= "->";
}
$step_name .= $row['step_name'];
} else {
if ($step_name) {
$step_name .= "->";
}
// 第一条未审核记录就是当前待审核记录
if ($first) {
$first = false;
$step_name .= "<b>" . $row['step_name'] . "</b>";
$reviewRow = $row;
$actual_user = explode(',', $reviewRow['actual_user']);
$planUser = $reviewRow['plan_user'];
$method = $reviewRow['method'];
$plan_user = explode(',', $planUser);
$diff = array_diff($plan_user, $actual_user);
foreach ($diff as $u) {
if (!$u) {
continue;
}
if ($u == $user) {
$mytype = 3;
}
$e = $employee->fetchRow("id = {$u}");
if ($reviewState) {
$reviewState .= ", ";
}
$reviewState .= $e['cname'] . "：未审核";
}
foreach ($actual_user as $u) {
if (!$u) {
continue;
}
$e = $employee->fetchRow("id = {$u}");
if ($reviewState) {
$reviewState .= ", ";
}
$reviewState .= $e['cname'] . "：已审核";
}
} else {
$step_name .= $row['step_name'];
}
}
}
}
} else {
if ($data[$i]['state'] == 'Obsolete') {
$reviewState = "已作废";
} else {
if ($data[$i]['state'] == 'Return') {
$reviewState = "退回";
} else {
$reviewState = $data[$i]['state'];
}
}
}
}
$data[$i]['step_name'] = $step_name;
$data[$i]['review_state'] = $reviewState;
$data[$i]['mytype'] = $mytype;
$data[$i]['record'] = $record->getHis($data[$i]['id'], 'materiel_desc');
}
// get file names
if (count($fileIds) > 0) {
$upload = new Dcc_Model_Upload();
$fileData = $upload->getJoinList("id in (" . implode(',', $fileIds) . ")", array(), array('id', 'name'));
$files = array();
foreach ($fileData as $f) {
$files[$f['id']] = $f['name'];
}
// data rebuild
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]['data_file_id_before'] && in_array($data[$i]['data_file_id_before'], $fileIds)) {
$data[$i]['data_file_before'] = $files[$data[$i]['data_file_id_before']];
}
if ($data[$i]['data_file_id_after'] && in_array($data[$i]['data_file_id_after'], $fileIds)) {
$data[$i]['data_file_after'] = $files[$data[$i]['data_file_id_after']];
}
if ($data[$i]['tsr_id_before'] && in_array($data[$i]['tsr_id_before'], $fileIds)) {
$data[$i]['tsr_before'] = $files[$data[$i]['tsr_id_before']];
}
if ($data[$i]['tsr_id_after'] && in_array($data[$i]['tsr_id_after'], $fileIds)) {
$data[$i]['tsr_after'] = $files[$data[$i]['tsr_id_after']];
}
if ($data[$i]['first_report_id_before'] && in_array($data[$i]['first_report_id_before'], $fileIds)) {
$data[$i]['first_report_before'] = $files[$data[$i]['first_report_id_before']];
}
if ($data[$i]['first_report_id_after'] && in_array($data[$i]['first_report_id_after'], $fileIds)) {
$data[$i]['first_report_after'] = $files[$data[$i]['first_report_id_after']];
}
}
}
// 转为json格式并输出
$resutl = array("totalCount" => $total, "topics" => $data);
echo Zend_Json::encode($resutl);
exit;
}
public function importAction()
{
$result = array('success' => true, 'info' => '导入成功');
$request = $this->getRequest()->getParams();
$now = date('Y-m-d H:i:s');
if (isset($_FILES['csv'])) {
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user_id = $user_session->user_info['user_id'];
$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);
$materiel = new Product_Model_Materiel();
$supply = new Product_Model_Bpartner();
$db = $materiel->getAdapter();
$file = fopen($tmp_file_path, "r");
$data = array();
while (!feof($file)) {
array_push($data, fgetcsv($file));
}
// 数据校验
if (count($data) <= 1) {
$result['success'] = false;
$result['info'] = "文件中无数据！";
fclose($file);
echo Zend_Json::encode($result);
exit;
}
// 文件格式 # 物料号 MPQ MOQ LT 供应商1 供应商2 备注
$errorCode = array();
$okData = array();
for ($i = 1; $i < count($data); $i++) {
$num = $i + 1;
$row = $data[$i];
if (count($row) < 2 || !$row[1]) {
continue;
}
for ($k = 0; $k < count($row); $k++) {
$row[$k] = str_replace("\"", "", $row[$k]);
}
// check materiel code
if ($materiel->checkExist($row[1])) {
// data
$code = $row[1];
$supply1Id = $supply2Id = '';
$mpq = $moq = $lt = 0;
$manufacturers = $remark = '';
if (isset($row[2]) && $row[2] && is_numeric($row[2])) {
$mpq = $row[2];
}
if (isset($row[3]) && $row[3] && is_numeric($row[3])) {
$moq = $row[3];
}
if (isset($row[4]) && $row[4] && is_numeric($row[4])) {
$lt = $row[4];
}
// supply
$supply1 = isset($row[5]) ? $row[5] : 0;
$supply2 = isset($row[6]) ? $row[6] : 0;
// check supply exists
if ($supply1) {
$supply1 = iconv('GBK', 'UTF-8', $supply1);
$where = "code = '{$supply1}' or cname like '{$supply1}' or ename like '{$supply1}' or concat(code, cname) like '{$supply1}' or concat(code, ename) like '{$supply1}'";
$supply1Data = $supply->getJoinList($where, array(), array('id'));
if (count($supply1Data) > 0) {
$supply1Id = $supply1Data[0]['id'];
}
}
if ($supply2) {
$supply2 = iconv('GBK', 'UTF-8', $supply2);
$where = "code = '{$supply2}' or cname like '{$supply2}' or ename like '{$supply2}' or concat(code, cname) like '{$supply2}' or concat(code, ename) like '{$supply2}'";
$supply2Data = $supply->getJoinList($where, array(), array('id'));
if (count($supply2Data) > 0) {
$supply2Id = $supply2Data[0]['id'];
}
}
$manufacturers = isset($row[7]) ? iconv('GBK', 'UTF-8', $row[7]) : '';
$remark = isset($row[8]) ? iconv('GBK', 'UTF-8', $row[8]) : '';
$profile = array('mpq' => $mpq, 'moq' => $moq, 'tod' => $lt, 'supply1' => $supply1Id, 'supply2' => $supply2Id, 'manufacturers' => $manufacturers, 'remark' => $remark);
$where = "code = '{$code}'";
try {
$materiel->update($profile, $where);
} catch (Exception $e) {
$errorCode[] = $code;
}
$okData[] = $row;
} else {
$errorCode[] = $row[1];
}
}
if (count($errorCode) > 0) {
$result['error'] = $errorCode;
}
fclose($file);
}
echo Zend_Json::encode($result);
exit;
}
