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