/**
* 获取最新申购单编号
* @param unknown $type_id
* @return string
*/
public function getNewNum($type_id)
{
$type = new Erp_Model_Purchse_Type();
$data = $type->fetchRow("id = " . $type_id)->toArray();
$type_code = $data['code'];
$pre = 'PR' . $type_code;
$num_pre = $pre . date('ymd');
$data = $this->fetchAll("number like '" . $num_pre . "%'", array('number desc'));
if ($data->count() == 0) {
$num = '01';
} else {
$last_item = $data->getRow(0)->toArray();
$new_order = intval(substr($last_item['number'], strlen($pre) + 6)) + 1;
$num = sprintf("%02d", $new_order);
}
return $num_pre . $num;
}
/**
* 编辑采购类别信息
*/
public function edittypeAction()
{
// 返回值数组
$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']);
$updated = $json->updated;
$inserted = $json->inserted;
$deleted = $json->deleted;
$type = new Erp_Model_Purchse_Type();
if (count($updated) > 0) {
foreach ($updated as $val) {
$data = array('active' => $val->active, 'chk_package_qty' => $val->chk_package_qty, 'code' => $val->code, 'name' => $val->name, 'tpl_id' => $val->tpl_id, 'req_flow_id' => $val->req_flow_id, 'order_flow_id' => $val->order_flow_id, 'description' => $val->description, 'remark' => $val->remark, 'update_time' => $now, 'update_user' => $user_id);
if ($type->fetchAll("id != " . $val->id . " and (name = '" . $val->name . "' or code = '" . $val->code . "')")->count() > 0) {
$result['success'] = false;
$result['info'] = '采购类别：' . $val->name . "已存在，请勿重复添加！";
} else {
try {
$type->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('active' => $val->active, 'chk_package_qty' => $val->chk_package_qty, 'code' => $val->code, 'name' => $val->name, 'tpl_id' => $val->tpl_id, 'req_flow_id' => $val->req_flow_id, 'order_flow_id' => $val->order_flow_id, 'description' => $val->description, 'remark' => $val->remark, 'create_time' => $now, 'create_user' => $user_id, 'update_time' => $now, 'update_user' => $user_id);
if ($type->fetchAll("name = '" . $val->name . "' or code = '" . $val->code . "'")->count() > 0) {
$result['success'] = false;
$result['info'] = '采购类别：' . $val->name . "已存在，请勿重复添加！";
} else {
try {
$type->insert($data);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
}
}
}
if (count($deleted) > 0) {
$req = new Erp_Model_Purchse_Req();
foreach ($deleted as $val) {
if ($req->fetchAll("type_id = " . $val->id)->count() == 0) {
try {
$type->delete("id = " . $val->id);
} catch (Exception $e) {
$result['success'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
} else {
$result['success'] = false;
$result['info'] = '采购类别' . $val->name . '已使用，不能删除';
echo Zend_Json::encode($result);
exit;
}
}
}
echo Zend_Json::encode($result);
exit;
}
