public function getData($pricelist_id) { $sql = $this->select()->setIntegrityCheck(false)->from(array('t1' => $this->_name))->joinLeft(array('t2' => $this->_dbprefix . 'user'), "t2.id = t1.create_user", array())->joinLeft(array('t3' => $this->_dbprefix . 'employee'), "t3.id = t2.employee_id", array('creater' => 'cname'))->joinLeft(array('t4' => $this->_dbprefix . 'user'), "t4.id = t1.update_user", array())->joinLeft(array('t5' => $this->_dbprefix . 'employee'), "t5.id = t4.employee_id", array('updater' => 'cname'))->where("t1.pricelist_id = " . $pricelist_id)->order("t1.date desc"); $data = $this->fetchAll($sql)->toArray(); $ladderQty = new Erp_Model_Warehouse_Ladderqty(); for ($i = 0; $i < count($data); $i++) { $data[$i]['create_time'] = strtotime($data[$i]['create_time']); $data[$i]['update_time'] = strtotime($data[$i]['update_time']); if ($ladderQty->fetchAll("ladder_id = " . $data[$i]['id'])->count() > 0) { $data[$i]['qty_range'] = 1; } else { $data[$i]['qty_range'] = 0; } } return $data; }
public function editladderqtyAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $request = $this->getRequest()->getParams(); // 价格清单ID $ladder_id = isset($request['ladder_id']) ? $request['ladder_id'] : null; if ($ladder_id) { $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']); $updated = $json->updated; $inserted = $json->inserted; $deleted = $json->deleted; $qty = new Erp_Model_Warehouse_Ladderqty(); if (count($updated) > 0) { foreach ($updated as $val) { $data = array('ladder_id' => $ladder_id, 'qty' => $val->qty, 'price' => $val->price, 'currency' => $val->currency, 'remark' => $val->remark, 'update_time' => $now, 'update_user' => $user_id); if ($qty->fetchAll("id != " . $val->id . " and ladder_id = " . $ladder_id . " and qty = " . $val->qty . " and price = " . $val->price)->count() > 0) { $result['success'] = false; $result['info'] = '价格清单重复,请勿重复添加!'; } else { try { $qty->update($data, "id = " . $val->id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } if (count($inserted) > 0) { foreach ($inserted as $val) { $data = array('ladder_id' => $ladder_id, 'qty' => $val->qty, 'price' => $val->price, 'currency' => $val->currency, 'remark' => $val->remark, 'create_time' => $now, 'create_user' => $user_id, 'update_time' => $now, 'update_user' => $user_id); if ($qty->fetchAll("ladder_id = " . $ladder_id . " and qty = " . $val->qty . " and price = " . $val->price)->count() > 0) { $result['success'] = false; $result['info'] = '价格清单重复,请勿重复添加!'; } else { try { $qty->insert($data); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } if (count($deleted) > 0) { foreach ($deleted as $val) { try { $qty->delete("id = " . $val->id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } echo Zend_Json::encode($result); exit; }