public function edititemsAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $json = json_decode($request['json']); $return_id = $json->return_id; $json_items = $json->items; $items_updated = $json_items->updated; $items_inserted = $json_items->inserted; $items_deleted = $json_items->deleted; $receive = new Erp_Model_Stock_receive(); $items = new Erp_Model_Purchse_Receiveitems(); $itemsorder = new Erp_Model_Purchse_Receiveitemsorder(); $receiveData = $receive->getData(null, $return_id, '采购退货'); // 更新 if (count($items_updated) > 0) { foreach ($items_updated as $val) { $data = array('order_number' => $val->items_order_number, 'code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'qty' => $val->items_qty, 'unit' => $val->items_unit, 'remark' => $val->items_remark, 'update_user' => $user_id, 'update_time' => $now); try { $items->update($data, "id = " . $val->items_id); // 记录分拆数据 $splitData = array('receive_number' => $receiveData['number'], 'receive_item_id' => $val->items_id, 'items_order_qty' => $val->items_order_qty, 'items_order_item_price' => $val->items_order_item_price, 'items_code' => $val->items_code, 'items_order_id' => $val->items_order_id, 'items_order_number' => $val->items_order_number); $this->saveSplitItem($splitData); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 此次退货货的采购订单号 $orderNumArr = array(); // 插入 if (count($items_inserted) > 0) { foreach ($items_inserted as $val) { $data = array('receive_id' => $return_id, 'order_number' => $val->items_order_number, 'code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'qty' => $val->items_qty, 'price' => $val->items_price, 'unit' => $val->items_unit, 'remark' => $val->items_remark, 'warehouse_code' => $val->items_warehouse_code, 'create_user' => $user_id, 'create_time' => $now, 'update_user' => $user_id, 'update_time' => $now); try { $receive_item_id = $items->insert($data); // 记录分拆数据 $splitData = array('return_number' => $receiveData['number'], 'receive_item_id' => $receive_item_id, 'items_qty' => $val->items_qty, 'items_price' => $val->items_price, 'items_code' => $val->items_code, 'items_order_id' => $val->items_order_id, 'items_order_item_id' => $val->items_order_item_id, 'items_warehouse_code' => $val->items_warehouse_code, 'items_order_number' => $val->items_order_number); $this->saveSplitItem($splitData); if (!in_array($val->items_order_number, $orderNumArr)) { array_push($orderNumArr, $val->items_order_number); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 更新总计 $items->refreshReceiveTotal($return_id); // 退货通知 $receive_items_order = new Erp_Model_Purchse_Receiveitemsorder(); $order = new Erp_Model_Purchse_Order(); $relatedUserInfo = count($orderNumArr) > 0 ? $receive_items_order->getReqRelatedUsers($orderNumArr) : array(); $member = new Admin_Model_Member(); $warehouse = new Erp_Model_Warehouse_Warehouse(); $noticeTo = $member->getMemberWithManagerByName('采购退货通知'); $noticeMails = array(); $noticeUsers = array(); foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } foreach ($relatedUserInfo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } $mail = new Application_Model_Log_Mail(); $supplierArr = array(); $i = 0; $itemsTable = '<style type="text/css"> table.gridtable { font-family: verdana,arial,sans-serif; font-size:11px; color:#333333; border-width: 1px; border-color: #666666; border-collapse: collapse; } table.gridtable th { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede; } table.gridtable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff; } </style><table class="gridtable"><tr> <th>#</th> <th>供应商</th> <th>采购订单</th> <th>物料号</th> <th>物料名称</th> <th>物料描述</th> <th>退货数量</th> <th>单位</th> <th>退货仓库</th> <th>备注</th> <th>订单信息</th> </tr>'; foreach ($items_inserted as $val) { $itemInfo = ''; if ($val->items_order_number) { $itemInfoData = $order->getItemDetails($val->items_order_number, $val->items_code); $itemInfo = '<table class="gridtable"><tr> <th>申请单号</th> <th>申请日期</th> <th>申请数量</th> <th>下单数量</th> <th>订单数量</th> <th>客户收件人地址简码</th> <th>客户合同号</th> </tr>'; foreach ($itemInfoData as $d) { $itemInfo .= '<tr> <td>' . $d['req_number'] . '</td> <td>' . $d['req_item_date'] . '</td> <td>' . $d['req_item_qty'] . '</td> <td>' . $d['order_req_item_qty'] . '</td> <td>' . $d['order_item_qty'] . '</td> <td>' . $d['customer_address'] . '</td> <td>' . $d['customer_aggrement'] . '</td> </tr>'; } $itemInfo .= '</table>'; $supplier = $d['supplier_code'] . ' ' . $d['supplier_name']; if (!in_array($supplier, $supplierArr)) { array_push($supplierArr, $supplier); } } $i++; $warehouseInfo = $warehouse->getInfoByCode($val->items_warehouse_code); $itemsTable .= '<tr> <td>' . $i . '</td> <td>' . $supplier . '</td> <td>' . $val->items_order_number . '</td> <td>' . $val->items_code . '</td> <td>' . $val->items_name . '</td> <td>' . $val->items_description . '</td> <td>' . $val->items_qty . '</td> <td>' . $val->items_unit . '</td> <td>' . $val->items_warehouse_code . ' ' . $warehouseInfo['name'] . '</td> <td>' . $val->items_remark . '</td> <td>' . $itemInfo . '</td> </tr>'; } $itemsTable .= '</table>'; $mailContent = '<div>采购退货,请登录系统查看:</div> <div> <p><b>退货单号:</b>' . $receiveData['number'] . '</p> <p><b>收货日期:</b>' . $receiveData['date'] . '</p> <p><b>收货人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>描述:</b>' . $receiveData['description'] . '</p> <p><b>备注:</b>' . $receiveData['remark'] . '</p> </div><div>' . $itemsTable . '</div><hr>'; $mailData = array('type' => '通知', 'subject' => '退货通知 - ' . $receiveData['number'] . ' - ' . implode(', ', $supplierArr), 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now, 'to' => implode(',', $noticeMails), 'user_id' => implode(',', $noticeUsers)); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } echo Zend_Json::encode($result); exit; }
public function mailByHand($receive_id) { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $receive = new Erp_Model_Stock_receive(); $items = new Erp_Model_Purchse_Receiveitems(); $itemsorder = new Erp_Model_Purchse_Receiveitemsorder(); $receive_items_order = new Erp_Model_Purchse_Receiveitemsorder(); $order = new Erp_Model_Purchse_Order(); $receiveData = $receive->getData(null, $receive_id); $itemsData = $items->getData($receive_id); $orderNumArr = array(); foreach ($itemsData as $item) { $numbers = explode(',', $item['items_order_number']); foreach ($numbers as $number) { if (!in_array($number, $orderNumArr)) { array_push($orderNumArr, $number); } } } // 订单关联人员(申请人、审核人) $relatedUserInfo = count($orderNumArr) > 0 ? $receive_items_order->getReqRelatedUsers($orderNumArr) : array(); // 到货通知 $member = new Admin_Model_Member(); $warehouse = new Erp_Model_Warehouse_Warehouse(); $noticeTo = $member->getMemberWithManagerByName('采购到货通知'); $noticeMails = array(); $noticeUsers = array(); foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } foreach ($relatedUserInfo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } $mail = new Application_Model_Log_Mail(); $supplierArr = array(); $supplierIdArr = array(); $i = 0; $itemsTable = '<style type="text/css"> table.gridtable { font-family: verdana,arial,sans-serif; font-size:11px; color:#333333; border-width: 1px; border-color: #666666; border-collapse: collapse; } table.gridtable th { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede; } table.gridtable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff; } </style><table class="gridtable"><tr> <th>#</th> <th>供应商</th> <th>采购订单</th> <th>物料号</th> <th>物料名称</th> <th>物料描述</th> <th>收货数量</th> <th>单位</th> <th>收货仓库</th> <th>备注</th> <th>备注</th> <th>申请信息</th> </tr>'; foreach ($itemsData as $val) { $itemInfo = ''; if ($val['items_order_number']) { $itemInfoData = $order->getItemDetails($val['items_order_number'], $val['items_code']); $itemInfo = '<table class="gridtable"><tr> <th>申请单号</th> <th>申请日期</th> <th>申请数量</th> <th>下单数量</th> <th>订单数量</th> <th>客户收件人地址简码</th> <th>客户合同号</th> </tr>'; foreach ($itemInfoData as $d) { $itemInfo .= '<tr> <td>' . $d['req_number'] . '</td> <td>' . $d['req_item_date'] . '</td> <td>' . $d['req_item_qty'] . '</td> <td>' . $d['order_req_item_qty'] . '</td> <td>' . $d['order_item_qty'] . '</td> <td>' . $d['customer_address'] . '</td> <td>' . $d['customer_aggrement'] . '</td> </tr>'; } $itemInfo .= '</table>'; } $i++; $numberArr = explode(',', $val['items_order_number']); foreach ($numberArr as $n) { $supplierData = $order->getSupplierByNumber($n); if (isset($supplierData['id']) && !in_array($supplierData['id'], $supplierIdArr)) { array_push($supplierArr, $supplierData['supplier_code'] . ' ' . $supplierData['supplier_name']); array_push($supplierIdArr, $supplierData['id']); } } $warehouseInfo = $warehouse->getInfoByCode($val['items_warehouse_code']); $itemsTable .= '<tr> <td>' . $i . '</td> <td>' . implode(', ', $supplierArr) . '</td> <td>' . $val['items_order_number'] . '</td> <td>' . $val['items_code'] . '</td> <td>' . $val['items_name'] . '</td> <td>' . $val['items_description'] . '</td> <td>' . $val['items_qty'] . '</td> <td>' . $val['items_unit'] . '</td> <td>' . $val['items_warehouse_code'] . ' ' . $warehouseInfo['name'] . '</td> <td>' . $val['items_remark'] . '</td> <td>' . $itemInfo . '</td> </tr>'; } $itemsTable .= '</table>'; $mailContent = '<div>采购到货,请登录系统查看:</div> <div> <p><b>收货单号:</b>' . $receiveData['number'] . '</p> <p><b>收货日期:</b>' . $receiveData['date'] . '</p> <p><b>收货人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>描述:</b>' . $receiveData['description'] . '</p> <p><b>备注:</b>' . $receiveData['remark'] . '</p> </div><div>' . $itemsTable . '</div><hr>'; $mailData = array('type' => '通知', 'subject' => '到货通知 - ' . $receiveData['number'] . ' - ' . implode(', ', $supplierArr), 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now, 'to' => implode(',', $noticeMails), 'user_id' => $user_id); try { // 记录邮件日志并发送邮件 //echo '<pre>';print_r($mailData);exit; $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } echo Zend_Json::encode($result); exit; }
public function editcatalogAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $request = $this->getRequest()->getParams(); $attribute = isset($request['attribute']) ? $request['attribute'] : false; $catalog = new Product_Model_Catalog(); if ($attribute) { $catalog_id = isset($request['id']) ? $request['id'] : null; $code = isset($request['code']) ? $request['code'] : null; $code_old = isset($request['code_old']) ? $request['code_old'] : null; $stage_id = isset($request['stage_id']) && $request['stage_id'] != '' ? $request['stage_id'] : null; $remark = isset($request['remark']) ? $request['remark'] : null; $date_dvt = isset($request['date_dvt']) && $request['date_dvt'] != '' ? $request['date_dvt'] : null; $qa1_date = isset($request['qa1_date']) && $request['qa1_date'] != '' ? $request['qa1_date'] : null; $qa2_date = isset($request['qa2_date']) && $request['qa2_date'] != '' ? $request['qa2_date'] : null; $evt_date = isset($request['evt_date']) && $request['evt_date'] != '' ? $request['evt_date'] : null; $mass_production_date = isset($request['mass_production_date']) && $request['mass_production_date'] != '' ? $request['mass_production_date'] : null; if ($catalog_id && $code) { if ($catalog->fetchAll("id != " . $catalog_id . " and code = '" . $code . "'")->count() == 0) { $data = array('code' => $code, 'code_old' => $code_old, 'stage_id' => $stage_id, 'remark' => $remark, 'date_dvt' => $date_dvt, 'qa1_date' => $qa1_date, 'qa2_date' => $qa2_date, 'evt_date' => $evt_date, 'mass_production_date' => $mass_production_date, 'update_time' => $now, 'update_user' => $user_id); $where = "id = " . $catalog_id; try { $catalog->update($data, $where); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '代码重复,请重新分配'; echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '信息不完整,编辑失败!'; } } else { $operate = isset($request['operate']) ? $request['operate'] : null; $review = isset($request['review']) ? $request['review'] : null; $id = isset($request['id']) ? $request['id'] : null; $ids = isset($request['ids']) ? $request['ids'] : null; $active = isset($request['active']) ? $request['active'] : null; $active = $active == 'on' ? 1 : 0; $description = isset($request['description']) ? $request['description'] : null; $remark = isset($request['remark']) ? $request['remark'] : null; $code_customer = isset($request['code_customer']) ? trim($request['code_customer']) : null; $model_customer = isset($request['model_customer']) ? trim($request['model_customer']) : null; $description_customer = isset($request['description_customer']) ? $request['description_customer'] : null; $type_id = isset($request['type_id']) ? $request['type_id'] : null; $type_id = isset($request['type_id']) ? $request['type_id'] : null; $series_id = isset($request['series_id']) ? $request['series_id'] : null; $series_id = isset($request['series_id']) ? $request['series_id'] : null; $developmode_id = isset($request['developmode_id']) ? $request['developmode_id'] : null; $model_standard = isset($request['model_standard']) ? trim($request['model_standard']) : null; $model_internal = isset($request['model_internal']) ? trim($request['model_internal']) : null; if ($operate == 'delete' && $id) { // 删除 try { if ($catalog->fetchAll("id = " . $id . " and auditor_id is not null")->count() == 1) { $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $catalog->update(array('delete' => 1, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [删除]'), "id = " . $id); } else { $catalog->delete("id = " . $id); $review = new Dcc_Model_Review(); $review->delete("type = 'product_add' and file_id = " . $id); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { if ($operate == 'disable' && $ids) { // 作废 $idArr = explode(',', $ids); foreach ($idArr as $id) { try { if ($catalog->fetchAll("id = " . $id . " and active = 1")->count() == 1) { $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $catalog->update(array('active' => 0, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [作废]'), "id = " . $id); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } else { if ($operate == 'enable' && $ids) { // 启用 $idArr = explode(',', $ids); foreach ($idArr as $id) { try { if ($catalog->fetchAll("id = " . $id . " and active = 0")->count() == 1) { $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $catalog->update(array('active' => 1, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [启用]'), "id = " . $id); } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } else { if ($operate == 'edit' && $id) { // 判断是否重复 if ($catalog->fetchAll("id != " . $id . " and model_internal = '" . $model_internal . "'")->count() == 0) { //type_id = ".$type_id." and series_id = ".$series_id." and $catalogData = $catalog->fetchRow("id = " . $id)->toArray(); $data = array('active' => $active, 'type_id' => $type_id, 'series_id' => $series_id, 'developmode_id' => $developmode_id, 'model_standard' => $model_standard, 'model_internal' => $model_internal, 'description' => $description, 'remark' => $remark, 'review' => $review == 1 ? 0 : 2, 'code_customer' => $code_customer, 'model_customer' => $model_customer, 'description_customer' => $description_customer, 'update_time' => $now, 'update_user' => $user_id, 'review_info' => $catalogData['review_info'] . '<br>' . $now . ': ' . $user_session->user_info['user_name'] . ' [修改]'); $where = "id = " . $id; try { $catalog->update($data, $where); if ($catalogData['review'] == 1) { // 修改 $member = new Admin_Model_Member(); $user = new Application_Model_User(); $employee = new Hra_Model_Employee(); $flow = new Admin_Model_Flow(); $step = new Admin_Model_Step(); $review = new Dcc_Model_Review(); $flowData = $flow->fetchRow("flow_name = '产品中心-审核'")->toArray(); // 获取审核阶段 $stepIds = $flowData['step_ids']; $stepArr = explode(',', $stepIds); $i = 0; foreach ($stepArr as $s) { $stepData = $step->fetchRow("id = " . $s)->toArray(); $step_user = $stepData['user'] != '' ? $stepData['user'] : null; $step_role = $stepData['dept'] != '' ? $stepData['dept'] : null; $reviewData = array('type' => 'product_add', 'file_id' => $id, 'step_name' => $stepData['step_name'], 'plan_user' => $step_user, 'plan_dept' => $step_role, 'method' => $stepData['method'], 'return' => $stepData['return']); $review->delete("type = 'product_add' AND file_id = " . $id); $review->insert($reviewData); // 第一阶段发送邮件通知 if ($i == 0) { $employeeIdArr = array(); if ($step_user) { $tmpArr = explode(',', $stepData['user']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t); } } } if ($step_role) { $tmpArr = $member->getMember($stepData['dept']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t['employee_id']); } } } $toAddress = array(); $toIds = array(); foreach ($employeeIdArr as $employeeId) { $em = $employee->getInfoById($employeeId); array_push($toAddress, $em['email']); $u = $user->fetchRow("employee_id = " . $employeeId)->toArray(); array_push($toIds, $u['id']); } $mail = new Application_Model_Log_Mail(); $mailContent = '<div>产品中心-修改产品信息,请登录系统审核:</div> <div> <p><b>标准型号:</b>' . $catalogData['model_standard'] . ' -> ' . $model_standard . '</p> <p><b>内部型号:</b>' . $catalogData['model_internal'] . ' -> ' . $model_internal . '</p> <p><b>描述:</b>' . $description . '</p> <p><b>申请人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>申请时间:</b>' . $now . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '产品中心-修改', 'to' => implode(',', $toAddress), 'cc' => $user_session->user_info['user_email'], 'user_id' => implode(',', $toIds), 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } $i++; } } else { // 变更 $noticeMails = array(); $noticeUsers = array(); $user = new Application_Model_User(); $employee = new Hra_Model_Employee(); $member = new Admin_Model_Member(); $reviewModel = new Dcc_Model_Review(); $reviewerInfo = $reviewModel->getReviewUserInfo('product_add', $id); // 审核人 $applyEmployeeData = $user->fetchRow("id = " . $catalogData['create_user'])->toArray(); $applyEmployee = $employee->fetchRow("id = " . $applyEmployeeData['employee_id'])->toArray(); // 申请人 $noticeTo = $member->getMemberWithManagerByName('产品中心-PM'); // 管理员 foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } foreach ($reviewerInfo as $r) { if ($r['email'] != '' && !in_array($r['user_id'], $noticeUsers)) { array_push($noticeMails, $r['email']); array_push($noticeUsers, $r['user_id']); } } if (!in_array($catalogData['create_user'], $noticeUsers)) { array_push($noticeMails, $applyEmployee['email']); array_push($noticeUsers, $catalogData['create_user']); } $mail = new Application_Model_Log_Mail(); $mailContent = '<div>产品中心产品信息变更,请登录系统查看:</div> <div> <p><b>标准型号:</b>' . $catalogData['model_standard'] . ' -> ' . $model_standard . '</p> <p><b>内部型号:</b>' . $catalogData['model_internal'] . ' -> ' . $model_internal . '</p> <p><b>描述:</b>' . $description . '</p> <p><b>申请人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>申请时间:</b>' . $now . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '产品中心-变更', 'cc' => $user_session->user_info['user_email'], 'to' => implode(',', $noticeMails), 'user_id' => $user_id, 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '当前型号已存在,请勿重复添加!'; echo Zend_Json::encode($result); exit; } } else { if ($operate == 'add') { if ($catalog->fetchAll("model_internal = '" . $model_internal . "'")->count() == 0) { //type_id = ".$type_id." and series_id = ".$series_id." and $data = array('active' => $active, 'type_id' => $type_id, 'series_id' => $series_id, 'developmode_id' => $developmode_id, 'model_standard' => $model_standard, 'model_internal' => $model_internal, 'remark' => $remark, 'description' => $description, 'code_customer' => $code_customer, 'model_customer' => $model_customer, 'description_customer' => $description_customer, 'create_time' => $now, 'create_user' => $user_id, 'update_time' => $now, 'update_user' => $user_id, 'review_info' => $now . ': ' . $user_session->user_info['user_name'] . ' [添加]'); try { $catalog_id = $catalog->insert($data); $member = new Admin_Model_Member(); $user = new Application_Model_User(); $employee = new Hra_Model_Employee(); $flow = new Admin_Model_Flow(); $step = new Admin_Model_Step(); $review = new Dcc_Model_Review(); $flowData = $flow->fetchRow("flow_name = '产品中心-审核'")->toArray(); // 获取审核阶段 $stepIds = $flowData['step_ids']; $stepArr = explode(',', $stepIds); $i = 0; foreach ($stepArr as $s) { $stepData = $step->fetchRow("id = " . $s)->toArray(); $step_user = $stepData['user'] != '' ? $stepData['user'] : null; $step_role = $stepData['dept'] != '' ? $stepData['dept'] : null; $reviewData = array('type' => 'product_add', 'file_id' => $catalog_id, 'step_name' => $stepData['step_name'], 'plan_user' => $step_user, 'plan_dept' => $step_role, 'method' => $stepData['method'], 'return' => $stepData['return']); $review->insert($reviewData); // 第一阶段发送邮件通知 if ($i == 0) { $employeeIdArr = array(); if ($step_user) { $tmpArr = explode(',', $stepData['user']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t); } } } if ($step_role) { $tmpArr = $member->getMember($stepData['dept']); foreach ($tmpArr as $t) { if (!in_array($t, $employeeIdArr)) { array_push($employeeIdArr, $t['employee_id']); } } } $toAddress = array(); $toIds = array(); foreach ($employeeIdArr as $employeeId) { $em = $employee->getInfoById($employeeId); array_push($toAddress, $em['email']); $u = $user->fetchRow("employee_id = " . $employeeId)->toArray(); array_push($toIds, $u['id']); } $mail = new Application_Model_Log_Mail(); $mailContent = '<div>产品中心新增产品型号,请登录系统审核:</div> <div> <p><b>标准型号:</b>' . $model_standard . '</p> <p><b>内部型号:</b>' . $model_internal . '</p> <p><b>描述:</b>' . $description . '</p> <p><b>申请人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>申请时间:</b>' . $now . '</p> </div>'; $mailData = array('type' => '消息', 'subject' => '产品中心-新建', 'to' => implode(',', $toAddress), 'user_id' => implode(',', $toIds), 'content' => $mailContent, 'add_date' => $now); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } $i++; } } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '当前型号已存在,请勿重复添加!'; echo Zend_Json::encode($result); exit; } } } } } } } echo Zend_Json::encode($result); exit; }
public function edititemsAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $json = json_decode($request['json']); $send_id = $json->send_id; $json_items = $json->items; $items_updated = $json_items->updated; $items_inserted = $json_items->inserted; $items_deleted = $json_items->deleted; $receive = new Erp_Model_Stock_receive(); $items = new Erp_Model_Purchse_Receiveitems(); $itemsSend = new Erp_Model_Sale_Receiveitemsordersale(); $stock = new Erp_Model_Stock_Stock(); $receiveData = $receive->getData(null, $send_id, '销售交货'); // 更新 if (count($items_updated) > 0) { foreach ($items_updated as $val) { $data = array('code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'qty' => $val->items_qty, 'unit' => $val->items_unit, 'customer_code' => $val->items_customer_code, 'customer_description' => $val->items_customer_description, 'warehouse_code' => $val->items_warehouse_code, 'remark' => $val->items_remark, 'update_user' => $user_id, 'update_time' => $now); try { $items->update($data, "id = " . $val->items_id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 插入 if (count($items_inserted) > 0) { foreach ($items_inserted as $val) { $total = round($val->items_qty * $val->items_price, 2); $code = $val->items_code_internal != '' ? $val->items_code_internal : $val->items_code; $product_code = $val->items_code_internal != '' ? $val->items_code : ''; $data = array('receive_id' => $send_id, 'code' => $code, 'product_code' => $product_code, 'name' => $val->items_name, 'description' => $val->items_description, 'qty' => $val->items_qty, 'price' => $val->items_price, 'total' => $total, 'unit' => $val->items_unit, 'customer_code' => $val->items_customer_code, 'customer_description' => $val->items_customer_description, 'warehouse_code' => $val->items_warehouse_code, 'remark' => $val->items_remark, 'order_number' => $val->items_order_number, 'create_user' => $user_id, 'create_time' => $now, 'update_user' => $user_id, 'update_time' => $now); try { $receive_item_id = $items->insert($data); // 记录分拆数据 $itemData = array('receive_number' => $receiveData['number'], 'receive_item_id' => $receive_item_id, 'items_order_item_id' => $val->items_order_item_id, 'items_order_currency' => $val->items_order_currency, 'items_order_date' => $val->items_order_date, 'items_code' => $code, 'items_product_code' => $product_code, 'items_customer_code' => $val->items_customer_code, 'items_customer_description' => $val->items_customer_description, 'items_remark' => $val->items_remark, 'items_qty' => $val->items_qty, 'items_price' => $val->items_price, 'items_warehouse_code' => $val->items_warehouse_code, 'items_order_id' => $val->items_order_id, 'items_order_number' => $val->items_order_number); $this->saveItemDetails($itemData); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 更新总计 $items->refreshReceiveTotal($send_id); if ($result['success']) { $member = new Admin_Model_Member(); $noticeMails = array(); $noticeUsers = array(); $noticeTo = $member->getMemberWithManagerByName('通知-销售交货'); foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } if (count($noticeMails)) { $warehouse = new Erp_Model_Warehouse_Warehouse(); $title = '销售交货-' . $receiveData['transaction_type']; $mailContent = '<div><b>' . $title . '</b>,请登录系统查看:</div> <div> <p><b>单据号:</b>' . $receiveData['number'] . '</p> <p><b>制单员:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>描述:</b>' . $receiveData['description'] . '</p> <p><b>备注:</b>' . $receiveData['remark'] . '</p> <p><b>时间:</b>' . $receiveData['create_time'] . '</p> </div><hr>'; $mailContent .= '<div><style type="text/css"> table.gridtable { font-family: verdana,arial,sans-serif; font-size:12px; color:#333333; border-width: 1px; border-color: #666666; border-collapse: collapse; } table.gridtable th { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede; } table.gridtable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff; } .delete{ text-decoration: line-through; color: #FF0000; } .update{ font-weight: bold; color: #000093; } .inactive{ font-weight: bold; color: #999999; } </style><table class="gridtable"> <tr> <th>#</th> <th>内部型号 / 物料号</th> <th>名称</th> <th>描述</th> <th>数量</th> <th>单位</th> <th>客户产品型号</th> <th>客户产品描述</th> <th>交货仓位</th> <th>备注</th> </tr>'; $itemsData = $items->getData($send_id); $i = 0; foreach ($itemsData as $d) { $i++; $warehouseData = $warehouse->getInfoByCode($d['items_warehouse_code']); $warehouseInfo = $warehouseData["code"]; if (isset($warehouseData["name"])) { $warehouseInfo = $warehouseData["code"] . ' ' . $warehouseData["name"]; } $mailContent .= '<tr> <td>' . $i . '</td> <td>' . $d['items_code'] . '</td> <td>' . $d['items_name'] . '</td> <td>' . $d['items_description'] . '</td> <td>' . $d['items_qty'] . '</td> <td>' . $d['items_unit'] . '</td> <td>' . $d['items_customer_code'] . '</td> <td>' . $d['items_customer_description'] . '</td> <td>' . $warehouseInfo . '</td> <td>' . $d['items_remark'] . '</td> </tr>'; } $mailContent .= '</table></div><hr>'; $mailData = array('type' => '通知', 'subject' => $title, 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now, 'to' => implode(',', $noticeMails), 'user_id' => $user_id); try { // 记录邮件日志并发送邮件 $mail = new Application_Model_Log_Mail(); $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } } echo Zend_Json::encode($result); exit; }
public function edititemsAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $json = json_decode($request['json']); $receive_id = $json->transfer_id; $json_items = $json->items; $items_updated = $json_items->updated; $items_inserted = $json_items->inserted; $items_deleted = $json_items->deleted; $receive = new Erp_Model_Stock_receive(); $items = new Erp_Model_Purchse_Receiveitems(); $stock = new Erp_Model_Stock_Stock(); $warehouse = new Erp_Model_Warehouse_Warehouse(); $receiveData = $receive->getData(null, $receive_id, '调拨'); // 更新 if (count($items_updated) > 0) { foreach ($items_updated as $val) { $data = array('code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'qty' => $val->items_qty, 'unit' => $val->items_unit, 'warehouse_code' => $val->items_warehouse_code, 'warehouse_code_transfer' => $val->items_warehouse_code_transfer, 'remark' => $val->items_remark, 'update_user' => $user_id, 'update_time' => $now); try { $items->update($data, "id = " . $val->items_id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 插入 if (count($items_inserted) > 0) { foreach ($items_inserted as $val) { $total = round($val->items_qty * $val->items_price, 2); $data = array('receive_id' => $receive_id, 'code' => $val->items_code, 'name' => $val->items_name, 'description' => $val->items_description, 'qty' => $val->items_qty, 'price' => $val->items_price, 'total' => $total, 'unit' => $val->items_unit, 'warehouse_code' => $val->items_warehouse_code, 'warehouse_code_transfer' => $val->items_warehouse_code_transfer, 'remark' => $val->items_remark, 'create_user' => $user_id, 'create_time' => $now, 'update_user' => $user_id, 'update_time' => $now); try { $receive_item_id = $items->insert($data); // 记录库存数据 $stockData = array('code' => $val->items_code, 'warehouse_code' => $val->items_warehouse_code_transfer, 'qty' => $val->items_qty, 'total' => $total, 'create_user' => $user_id, 'create_time' => $now, 'doc_type' => '调拨收货', 'transaction_type' => $receiveData['transaction_type'], 'doc_number' => $receiveData['number']); $stock->insert($stockData); $qty = round(0 - $val->items_qty, 4); $total = round(0 - $total, 2); // 记录库存数据 $stockData = array('code' => $val->items_code, 'warehouse_code' => $val->items_warehouse_code, 'qty' => $qty, 'total' => $total, 'create_user' => $user_id, 'create_time' => $now, 'doc_type' => '调拨发货', 'doc_number' => $receiveData['number']); $stock->insert($stockData); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } // 更新总计 $items->refreshReceiveTotal($receive_id); if ($result['success']) { // 转储通知(针对从待检仓转出) if ($receiveData['transaction_type'] == '外购入库' && $receiveData['order_id'] != '') { // 计算收货入库数量(订单、申请) $receiveModel = new Erp_Model_Stock_Receive(); $receiveModel->correctInStockQty($receive_id); $member = new Admin_Model_Member(); $noticeMails = array(); $noticeUsers = array(); $noticeTo = $member->getMemberWithManagerByName('外购入库'); // 通知:外购入库 foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } $noticeTo = $member->getMemberWithManagerByName('库房'); // 通知:库房 foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } // 通知:QA $noticeTo = $member->getMemberWithManagerByName('QA'); foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } // 通知:外购入库通知 $noticeTo = $member->getMemberWithManagerByName('外购入库通知'); foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } // 获取采购订单信息 $order = new Erp_Model_Purchse_Order(); $order_data = $order->getData(null, $receiveData['order_id']); // 获取采购订单相关参与人员 $receive_items_order = new Erp_Model_Purchse_Receiveitemsorder(); $relatedUserInfo = $receive_items_order->getReqRelatedUsers(array($order_data['number'])); foreach ($relatedUserInfo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } $mail = new Application_Model_Log_Mail(); $itemsTable = '<style type="text/css"> table.gridtable { font-family: verdana,arial,sans-serif; font-size:11px; color:#333333; border-width: 1px; border-color: #666666; border-collapse: collapse; } table.gridtable th { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede; } table.gridtable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff; } </style><table class="gridtable"><tr> <th>#</th> <th>物料号</th> <th>物料名称</th> <th>物料描述</th> <th>数量</th> <th>单位</th> <th>出库仓位</th> <th>入库仓位</th> <th>备注</th> </tr>'; $i = 0; foreach ($items_inserted as $val) { $i++; $warehouseInfo = $warehouse->getInfoByCode($val->items_warehouse_code); $warehouseTransferInfo = $warehouse->getInfoByCode($val->items_warehouse_code_transfer); $stockQty = $stock->getStockQty($val->items_code, array($val->items_warehouse_code)); $stockTransferQty = $stock->getStockQty($val->items_code, array($val->items_warehouse_code_transfer)); $itemsTable .= '<tr> <td>' . $i . '</td> <td>' . $val->items_code . '</td> <td>' . $val->items_name . '</td> <td>' . $val->items_description . '</td> <td>' . $val->items_qty . '</td> <td>' . $val->items_unit . '</td> <td>' . $val->items_warehouse_code . ' ' . $warehouseInfo['name'] . ' [' . $stockQty['total'] . ']</td> <td>' . $val->items_warehouse_code_transfer . ' ' . $warehouseTransferInfo['name'] . ' [' . $stockTransferQty['total'] . ']</td> <td>' . $val->items_remark . '</td> </tr>'; } $itemsTable .= '</table>'; $title = '库存调拨 - ' . $receiveData['transaction_type'] . ' [' . $order_data['supplier_code'] . ' ' . $order_data['supplier_ename'] . ']'; $mailContent = '<div>' . $title . ',请登录系统查看:</div> <div> <p><b>单据号:</b>' . $receiveData['number'] . '</p> <p><b>日期:</b>' . $receiveData['date'] . '</p> <p><b>采购订单:</b>' . $order_data['number'] . '</p> <p><b>制单人:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>描述:</b>' . $receiveData['description'] . '</p> <p><b>备注:</b>' . $receiveData['remark'] . '</p> </div><div>' . $itemsTable . '</div><hr>'; $mailData = array('type' => '通知', 'subject' => $title, 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now, 'to' => implode(',', $noticeMails), 'user_id' => $user_id); try { // 记录邮件日志并发送邮件 $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } else { $member = new Admin_Model_Member(); $noticeMails = array(); $noticeUsers = array(); $noticeTo = $member->getMemberWithManagerByName('通知-库存交易-调拨'); foreach ($noticeTo as $n) { if ($n['email'] != '' && !in_array($n['user_id'], $noticeUsers)) { array_push($noticeMails, $n['email']); array_push($noticeUsers, $n['user_id']); } } if (count($noticeMails)) { $warehouse = new Erp_Model_Warehouse_Warehouse(); $title = '库存交易-调拨-' . $receiveData['transaction_type']; $mailContent = '<div><b>' . $title . '</b>,请登录系统查看:</div> <div> <p><b>单据号:</b>' . $receiveData['number'] . '</p> <p><b>制单员:</b>' . $user_session->user_info['user_name'] . '</p> <p><b>描述:</b>' . $receiveData['description'] . '</p> <p><b>备注:</b>' . $receiveData['remark'] . '</p> <p><b>时间:</b>' . $receiveData['create_time'] . '</p> </div><hr>'; $mailContent .= '<div><style type="text/css"> table.gridtable { font-family: verdana,arial,sans-serif; font-size:12px; color:#333333; border-width: 1px; border-color: #666666; border-collapse: collapse; } table.gridtable th { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #dedede; } table.gridtable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #666666; background-color: #ffffff; } .delete{ text-decoration: line-through; color: #FF0000; } .update{ font-weight: bold; color: #000093; } .inactive{ font-weight: bold; color: #999999; } </style><table class="gridtable"> <tr> <th>#</th> <th>物料号</th> <th>名称</th> <th>描述</th> <th>数量</th> <th>单位</th> <th>出库仓位</th> <th>入货仓位</th> <th>备注</th> </tr>'; $itemsData = $items->getData($receive_id); $i = 0; foreach ($itemsData as $d) { $i++; $warehouseData = $warehouse->getInfoByCode($d['items_warehouse_code']); $warehouseInfo = $warehouseData["code"]; if (isset($warehouseData["name"])) { $warehouseInfo = $warehouseData["code"] . ' ' . $warehouseData["name"]; } $warehouseTransferData = $warehouse->getInfoByCode($d['items_warehouse_code_transfer']); $warehouseTransferInfo = $warehouseTransferData["code"]; if (isset($warehouseTransferData["name"])) { $warehouseTransferInfo = $warehouseTransferData["code"] . ' ' . $warehouseTransferData["name"]; } $mailContent .= '<tr> <td>' . $i . '</td> <td>' . $d['items_code'] . '</td> <td>' . $d['items_name'] . '</td> <td>' . $d['items_description'] . '</td> <td>' . $d['items_qty'] . '</td> <td>' . $d['items_unit'] . '</td> <td>' . $warehouseInfo . '</td> <td>' . $warehouseTransferInfo . '</td> <td>' . $d['items_remark'] . '</td> </tr>'; } $mailContent .= '</table></div><hr>'; $mailData = array('type' => '通知', 'subject' => $title, 'cc' => $user_session->user_info['user_email'], 'content' => $mailContent, 'add_date' => $now, 'to' => implode(',', $noticeMails), 'user_id' => $user_id); try { // 记录邮件日志并发送邮件 $mail = new Application_Model_Log_Mail(); $mail->send($mail->insert($mailData)); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); } } } } echo Zend_Json::encode($result); exit; }