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