public function getInvoiceOrderItemsList($customer_id, $currency, $key = null)
{
$data = array();
$sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name), array('order_tax_id' => 'tax_id', 'order_tax_name' => 'tax_name', 'order_tax_rate' => 'tax_rate', 'order_price_tax' => 'price_tax', 'order_sales_id' => 'sales_id', 'order_customer_id' => 'customer_id', 'order_date', 'order_number' => 'number', 'order_remark' => 'remark', 'order_currency' => 'currency', 'order_currency_rate' => 'currency_rate', 'order_type_id' => 'type_id'))->joinLeft(array('t2' => $this->_dbprefix . 'user'), "t1.create_user = t2.id", array())->joinLeft(array('t3' => $this->_dbprefix . 'employee'), "t2.employee_id = t3.id", array('creater' => 'cname'))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t1.update_user = t4.id", array())->joinLeft(array('t5' => $this->_dbprefix . 'employee'), "t4.employee_id = t5.id", array('updater' => 'cname'))->joinLeft(array('t7' => $this->_dbprefix . 'erp_pur_type'), "t1.type_id = t7.id", array('order_type_name' => 'name'))->joinLeft(array('t8' => $this->_dbprefix . 'erp_sale_order_items'), "t1.id = t8.order_id", array('id', 'order_id', 'request_date', 'code', 'name', 'description', 'remark', 'price', 'qty', 'unit'))->joinLeft(array('t9' => $this->_dbprefix . 'bpartner'), "t1.customer_id = t9.id", array('order_customer_code' => 'code', 'order_customer_name' => new Zend_Db_Expr("case when t9.cname != '' then t9.cname else t9.ename end")))->joinLeft(array('t10' => $this->_dbprefix . 'bpartner_contact'), "t1.customer_contact_id = t10.id", array('order_customer_contact' => new Zend_Db_Expr("concat(t10.name, ' [', t10.tel, ']')")))->where("t1.customer_id = " . $customer_id . " and t1.currency = '" . $currency . "' and t1.state = 2 and t1.active = 1");
if ($key) {
$sql->where("t1.number like '%" . $key . "%' \n or t1.remark like '%" . $key . "%' \n or t3.cname like '%" . $key . "%' \n or t3.ename like '%" . $key . "%' \n or t7.name like '%" . $key . "%' \n or t8.code like '%" . $key . "%' \n or t8.name like '%" . $key . "%' \n or t8.description like '%" . $key . "%'");
}
/* echo $sql;
exit; */
$data = $this->fetchAll($sql)->toArray();
$items_invoice = new Erp_Model_Sale_Invoiceitems();
$items_receive = new Erp_Model_Purchse_Receiveitemsorder();
// 交货
$sales = new Erp_Model_Sale_Sales();
for ($i = 0; $i < count($data); $i++) {
// 获取已开票数量
$data[$i]['qty_invoice'] = $items_invoice->getQty($data[$i]['id']);
$data[$i]['qty_left'] = $data[$i]['qty'] - $data[$i]['qty_invoice'];
$data[$i]['qty_invoice'] = 0;
$salesData = $sales->getData($data[$i]['order_sales_id']);
$data[$i]['order_sales_name'] = isset($salesData['cname']) ? $salesData['cname'] : '';
// 交货数量
$data[$i]['qty_send'] = 0 - $items_receive->getQty('sale_order', $data[$i]['id']);
// 交货（负数）
$data[$i]['description'] = str_replace("'", "\\'", $data[$i]['description']);
}
return $data;
}
public function getData($order_id)
{
$result = array();
$data = $this->fetchAll("order_id = " . $order_id)->toArray();
$item = new Erp_Model_Purchse_Receiveitemsorder();
$reqItem = new Erp_Model_Purchse_Orderitemsreq();
foreach ($data as $d) {
$active = $d['active'] == 1 ? true : false;
$qty_receive = $item->getQty('order', $d['id']);
$itemReqInfo = $reqItem->getOrderItemReqInfo($d['id']);
$req_item_ids = array();
$req_qtys = array();
foreach ($itemReqInfo as $info) {
array_push($req_item_ids, $info['req_item_id']);
array_push($req_qtys, $info['qty']);
}
$items_req_item_id = implode(',', $req_item_ids);
$items_req_qty = implode(',', $req_qtys);
array_push($result, array('items_id' => $d['id'], 'items_order_id' => $d['order_id'], 'items_req_number' => $d['req_number'], 'items_active' => $active, 'items_code' => $d['code'], 'items_name' => $d['name'], 'items_description' => $d['description'], 'items_supplier_code' => $d['supplier_code'], 'items_supplier_codename' => $d['supplier_codename'], 'items_supplier_description' => $d['supplier_description'], 'items_warehouse_code' => $d['warehouse_code'], 'items_qty' => $d['qty'], 'items_qty_receive' => $qty_receive, 'items_unit' => $d['unit'], 'items_price' => $d['price'], 'items_total' => $d['total'], 'items_request_date' => $d['request_date'], 'items_dept_id' => $d['dept_id'], 'items_project_info' => $d['project_info'], 'items_req_item_id' => $items_req_item_id, 'items_req_qty' => $items_req_qty, 'items_remark' => $d['remark']));
}
return $result;
}
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 getOrderStatistics($condition = array())
{
$sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name), array('order_price_tax' => 'price_tax', 'order_state' => new Zend_Db_Expr("case when t1.state = 0 then '审核中' when t1.state = 1 then '拒绝' else '批准' end"), 'order_create_time' => 'create_time', 'order_release_time' => 'release_time', 'order_buyer_id' => 'buyer_id', 'order_supplier_id' => 'supplier_id', 'order_date', 'order_number' => 'number', 'order_remark' => 'remark', 'order_currency' => 'currency', 'order_type_id' => 'type_id'))->joinLeft(array('t2' => $this->_dbprefix . 'user'), "t1.create_user = t2.id", array())->joinLeft(array('t3' => $this->_dbprefix . 'employee'), "t2.employee_id = t3.id", array('creater' => 'cname'))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t1.update_user = t4.id", array())->joinLeft(array('t5' => $this->_dbprefix . 'employee'), "t4.employee_id = t5.id", array('updater' => 'cname'))->joinLeft(array('t7' => $this->_dbprefix . 'erp_pur_type'), "t1.type_id = t7.id", array('order_type_name' => 'name'))->joinLeft(array('t8' => $this->_dbprefix . 'erp_pur_order_items'), "t1.id = t8.order_id", array('delivery_date', 'delivery_date_remark', 'active', 'id', 'order_id', 'request_date', 'code', 'name', 'description', 'remark', 'supplier_code', 'supplier_codename', 'supplier_description', 'warehouse_code', 'price', 'qty', 'unit', 'project_info', 'req_number'))->joinLeft(array('t9' => $this->_dbprefix . 'bpartner'), "t1.supplier_id = t9.id", array('order_supplier_code' => 'code', 'order_supplier_name' => new Zend_Db_Expr("case when t9.cname != '' then t9.cname else t9.ename end")))->joinLeft(array('t10' => $this->_dbprefix . 'bpartner_contact'), "t1.supplier_contact_id = t10.id", array('order_supplier_contact' => new Zend_Db_Expr("concat(t10.name, ' [', t10.tel, ']')")))->joinLeft(array('t11' => $this->_dbprefix . 'erp_pur_order_items_req'), "t11.order_item_id = t8.id", array('req_item_ids' => new Zend_Db_Expr("group_concat(t11.req_item_id)")))->joinLeft(array('t12' => $this->_dbprefix . 'erp_pur_req_items'), "t12.id = t11.req_item_id", array('qty_req' => new Zend_Db_Expr('sum(t12.qty)'), 'order_req_num', 'customer_address', 'customer_aggrement'))->where("t1.active = 1")->group("t8.id")->order(array('t1.number desc', 't1.create_time desc'));
// 状态
if ($condition['state'] != null) {
$sql->where("t1.state = " . $condition['state']);
}
// 日前从
if ($condition['date_from']) {
$sql->where("t1.create_time >= '" . $condition['date_from'] . " 00:00:00'");
}
// 日期至
if ($condition['date_to']) {
$sql->where("t1.create_time <= '" . $condition['date_to'] . " 23:59:59'");
}
// 采购类别
if ($condition['type']) {
$type = json_decode($condition['type']);
if (count($type)) {
$type_con = "t1.type_id = " . $type[0];
for ($i = 1; $i < count($type); $i++) {
$type_con .= " or t1.type_id = " . $type[$i];
}
$sql->where($type_con);
}
}
// 需求部门
if ($condition['dept']) {
$dept = json_decode($condition['dept']);
if (count($dept)) {
$dept_con = "t8.dept_id = " . $dept[0];
for ($i = 1; $i < count($dept); $i++) {
$dept_con .= " or t8.dept_id = " . $dept[$i];
}
$sql->where($dept_con);
}
}
// 采购员
if ($condition['buyer']) {
$buyer = json_decode($condition['buyer']);
if (count($buyer)) {
$buyer_con = "t1.buyer_id = " . $buyer[0];
for ($i = 1; $i < count($buyer); $i++) {
$buyer_con .= " or t1.buyer_id = " . $buyer[$i];
}
$sql->where($buyer_con);
}
}
if ($condition['key']) {
$sql->where("t9.code like '%" . $condition['key'] . "%' or t9.cname like '%" . $condition['key'] . "%' or t9.ename like '%" . $condition['key'] . "%' or t3.cname like '%" . $condition['key'] . "%' or t3.ename like '%" . $condition['key'] . "%' or t1.number like '%" . $condition['key'] . "%' or t1.remark like '%" . $condition['key'] . "%' or t3.cname like '%" . $condition['key'] . "%' or t3.ename like '%" . $condition['key'] . "%' or t7.name like '%" . $condition['key'] . "%' or t8.code like '%" . $condition['key'] . "%' or t8.name like '%" . $condition['key'] . "%' or t8.description like '%" . $condition['key'] . "%'");
}
$total = $this->fetchAll($sql)->count();
/* echo $sql;
exit; */
if ($condition['option'] != 'csv') {
$sql->limitPage($condition['page'], $condition['limit']);
}
$data = $this->fetchAll($sql)->toArray();
//echo '<pre>';print_r($data);exit;
$items_receive = new Erp_Model_Purchse_Receiveitemsorder();
$items_invoice = new Erp_Model_Purchse_Invoiceitems();
$buyer = new Erp_Model_Purchse_Buyer();
$req = new Erp_Model_Purchse_Req();
$operateModel = new Application_Model_Log_Operate();
$receiveModel = new Erp_Model_Purchse_Reqitemsreceived();
for ($i = 0; $i < count($data); $i++) {
// 入库日志
$in_stock_info = $receiveModel->getReceivedInfo('order', $data[$i]['id']);
$data[$i]['in_stock_qty'] = $in_stock_info['qty'];
$data[$i]['in_stock_info'] = implode(',', $in_stock_info['info']);
// 交期回复日志
if ($data[$i]['delivery_date'] != '' || $data[$i]['delivery_date_remark'] != '') {
$logInfo = array();
$log = $operateModel->getLogByOperateAndTargetId('采购交期回复', $data[$i]['id']);
foreach ($log as $l) {
$content = Zend_Json::decode($l['content']);
$logText = $content['time'] . ' [' . $content['delivery_date'] . '] [' . $content['delivery_date_remark'] . '] ' . $content['user'];
array_push($logInfo, $logText);
}
$data[$i]['delivery_reply_log'] = implode(',', $logInfo);
}
// 获取采购申请数量（合并下单的申请分拆显示）
$data[$i]['req_info'] = '';
if ($data[$i]['req_item_ids'] != '') {
$item_ids = explode(',', $data[$i]['req_item_ids']);
$req_item_data = $req->getReqQty($item_ids);
$reqInfoArr = array();
foreach ($req_item_data as $req_info) {
array_push($reqInfoArr, $req_info['number'] . ' [' . $req_info['qty'] . '] [' . $req_info['time'] . ']');
}
$data[$i]['req_info'] = implode(',', $reqInfoArr);
}
$data[$i]['order_supplier'] = $data[$i]['order_supplier_code'] . $data[$i]['order_supplier_name'];
$data[$i]['qty_receive'] = 0;
$data[$i]['receive_info'] = '';
if ($data[$i]['id']) {
if ($data[$i]['code'] != '') {
// 已收货物料：从采购收货
$receiveData = $items_receive->getOrderItemReceivedQty($data[$i]['id']);
$receiveInfoArr = array();
foreach ($receiveData as $r) {
$data[$i]['qty_receive'] += $r['qty'];
array_push($receiveInfoArr, $r['number'] . ' [' . $r['qty'] . '] [' . $r['time'] . ']');
}
$data[$i]['receive_info'] = implode(',', $receiveInfoArr);
} else {
// 已收货非物料：从采购发票
$data[$i]['qty_receive'] = $items_invoice->getQty($data[$i]['id'], 1);
}
}
$data[$i]['qty_left'] = $data[$i]['qty'] - $data[$i]['qty_receive'];
$buyerData = $buyer->getData($data[$i]['order_buyer_id']);
$data[$i]['order_buyer_name'] = isset($buyerData['cname']) ? $buyerData['cname'] : '';
}
if ($condition['option'] == 'csv') {
$data_csv = array();
$showPrice = false;
if (Application_Model_User::checkPermissionByRoleName('系统管理员') || Application_Model_User::checkPermissionByRoleName('采购人员') || Application_Model_User::checkPermissionByRoleName('财务人员')) {
$showPrice = true;
}
if ($showPrice) {
$title = array('cnt' => '#', 'active' => '启用', 'order_number' => '订单号', 'order_state' => '订单状态', 'order_date' => '订单日期', 'order_buyer_name' => '采购员', 'order_type_name' => '类别', 'order_supplier_code' => '供应商代码', 'order_supplier_name' => '供应商名称', 'code' => '物料号', 'price' => '价格', 'order_price_tax' => '含税', 'qty' => '订单数量', 'qty_req' => '申请数量', 'qty_receive' => '到货数量', 'receive_info' => '到货信息', 'in_stock_qty' => '入库数量', 'in_stock_info' => '入库信息', 'qty_left' => '未到货数量', 'request_date' => '需求交期', 'delivery_date' => '预计交期', 'delivery_date_remark' => '交期备注', 'order_req_num' => '订货产品出库申请号', 'customer_address' => '客户收件人地址简码', 'customer_aggrement' => '客户合同号', 'name' => '名称', 'description' => '描述', 'req_info' => '申购单号', 'remark' => '备注', 'order_create_date' => '下单日期', 'order_create_time' => '下单时间', 'order_release_date' => '批准日期', 'order_release_time' => '批准时间');
} else {
$title = array('cnt' => '#', 'active' => '启用', 'order_number' => '订单号', 'order_state' => '订单状态', 'order_date' => '订单日期', 'order_buyer_name' => '采购员', 'order_type_name' => '类别', 'order_supplier_code' => '供应商代码', 'order_supplier_name' => '供应商名称', 'code' => '物料号', 'qty' => '订单数量', 'qty_req' => '申请数量', 'qty_receive' => '到货数量', 'receive_info' => '到货信息', 'in_stock_qty' => '入库数量', 'in_stock_info' => '入库信息', 'qty_left' => '未到货数量', 'request_date' => '需求交期', 'delivery_date' => '预计交期', 'delivery_date_remark' => '交期备注', 'order_req_num' => '订货产品出库申请号', 'customer_address' => '客户收件人地址简码', 'customer_aggrement' => '客户合同号', 'name' => '名称', 'description' => '描述', 'req_info' => '申购单号', 'remark' => '备注', 'order_create_date' => '下单日期', 'order_create_time' => '下单时间', 'order_release_date' => '批准日期', 'order_release_time' => '批准时间');
}
array_push($data_csv, $title);
$i = 0;
foreach ($data as $d) {
$i++;
if ($showPrice) {
$info = array('cnt' => $i, 'active' => $d['active'] == 1 ? '是' : '否', 'order_number' => $d['order_number'], 'order_state' => $d['order_state'], 'order_date' => $d['order_date'], 'order_buyer_name' => $d['order_buyer_name'], 'order_type_name' => $d['order_type_name'], 'order_supplier_code' => $d['order_supplier_code'], 'order_supplier_name' => $d['order_supplier_name'], 'code' => $d['code'], 'price' => $d['price'], 'order_price_tax' => $d['order_price_tax'] == 1 ? '是' : '否', 'qty' => $d['qty'], 'qty_req' => $d['qty_req'], 'qty_receive' => $d['qty_receive'], 'receive_info' => $d['receive_info'], 'in_stock_qty' => $d['in_stock_qty'], 'in_stock_info' => $d['in_stock_info'], 'qty_left' => $d['qty_left'], 'request_date' => $d['request_date'], 'delivery_date' => $d['delivery_date'], 'delivery_date_remark' => $d['delivery_date_remark'], 'order_req_num' => $d['order_req_num'], 'customer_address' => $d['customer_address'], 'customer_aggrement' => $d['customer_aggrement'], 'name' => $d['name'], 'description' => $d['description'], 'req_info' => $d['req_info'], 'remark' => $d['remark'], 'order_create_date' => $d['order_create_time'] != '' ? date('Y-m-d', strtotime($d['order_create_time'])) : '', 'order_create_time' => $d['order_create_time'] != '' ? date('H:i:s', strtotime($d['order_create_time'])) : '', 'order_release_date' => $d['order_release_time'] != '' ? date('Y-m-d', strtotime($d['order_release_time'])) : '', 'order_release_time' => $d['order_release_time'] != '' ? date('H:i:s', strtotime($d['order_release_time'])) : '');
} else {
$info = array('cnt' => $i, 'active' => $d['active'] == 1 ? '是' : '否', 'order_number' => $d['order_number'], 'order_state' => $d['order_state'], 'order_date' => $d['order_date'], 'order_buyer_name' => $d['order_buyer_name'], 'order_type_name' => $d['order_type_name'], 'order_supplier_code' => $d['order_supplier_code'], 'order_supplier_name' => $d['order_supplier_name'], 'code' => $d['code'], 'qty' => $d['qty'], 'qty_req' => $d['qty_req'], 'qty_receive' => $d['qty_receive'], 'receive_info' => $d['receive_info'], 'in_stock_qty' => $d['in_stock_qty'], 'in_stock_qty' => $d['in_stock_info'], 'qty_left' => $d['qty_left'], 'request_date' => $d['request_date'], 'delivery_date' => $d['delivery_date'], 'delivery_date_remark' => $d['delivery_date_remark'], 'order_req_num' => $d['order_req_num'], 'customer_address' => $d['customer_address'], 'customer_aggrement' => $d['customer_aggrement'], 'name' => $d['name'], 'description' => $d['description'], 'req_info' => $d['req_info'], 'remark' => $d['remark'], 'order_create_date' => $d['order_create_time'] != '' ? date('Y-m-d', strtotime($d['order_create_time'])) : '', 'order_create_time' => $d['order_create_time'] != '' ? date('H:i:s', strtotime($d['order_create_time'])) : '', 'order_release_date' => $d['order_release_time'] != '' ? date('Y-m-d', strtotime($d['order_release_time'])) : '', 'order_release_time' => $d['order_release_time'] != '' ? date('H:i:s', strtotime($d['order_release_time'])) : '');
}
array_push($data_csv, $info);
}
return $data_csv;
}
return array('total' => $total, 'rows' => $data);
}
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;
}