public function updateArchiveTime()
{
$data = $this->fetchAll("bom_upd_time is null or bom_upd_time = '0000-00-00 00:00:00'")->toArray();
$newbom = new Product_Model_Newbom();
$updbom = new Product_Model_Updbom();
foreach ($data as $fa) {
if (!$fa['nid']) {
continue;
}
$nid = $fa['nid'];
if ($fa['ver'] == '1.0') {
$row = $newbom->fetchRow("id = {$nid}");
if ($row) {
$archive_time = $row['archive_time'];
}
} else {
$row = $updbom->fetchRow("id = {$nid}");
if ($row) {
$archive_time = $row['archive_time'];
}
}
if (isset($archive_time)) {
$this->update(array('bom_upd_time' => $archive_time), "sid = " . $fa['sid']);
}
}
}
public function savedraftAction()
{
// 返回值数组
$result = array('success' => true, 'result' => true);
$request = $this->getRequest()->getParams();
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$val = (object) $request;
$newbom = new Product_Model_Newbom();
$record = new Dcc_Model_Record();
// 保存数据
$data = array("description" => isset($val->description) ? $val->description : "", "state" => 'Draft', "remark" => isset($val->remark) ? $val->remark : "", "create_time" => $now, "create_user" => $user, "update_time" => $now, "update_user" => $user);
try {
$id = $newbom->insert($data);
if ($id) {
$result['nid'] = $id;
// 操作记录
$data = array('type' => "bom", 'table_name' => "oa_product_bom_new", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "新建", 'ip' => $_SERVER['REMOTE_ADDR']);
$record->insert($data);
// 自定义字段
$attrval = new Admin_Model_Formval();
$menu = 'oa_product_bom_new_' . $id;
$attrval->delete("menu = '" . $menu . "'");
foreach ($request as $field => $value) {
if (stripos($field, "intelligenceField") !== false && $value) {
$attrId = str_replace("intelligenceField", "", $field);
$formval = array('attrid' => $attrId, 'value' => $value, 'menu' => $menu);
$attrval->insert($formval);
}
}
}
} catch (Exception $e) {
$result['result'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
echo Zend_Json::encode($result);
exit;
}
/**
* @abstract 删除
* @return null
*/
public function removeAction()
{
// 返回值数组
$result = array('success' => true, 'result' => true, 'info' => '删除成功');
$request = $this->getRequest()->getParams();
$now = date('Y-m-d H:i:s');
$user_session = new Zend_Session_Namespace('user');
$user = $user_session->user_info['employee_id'];
$json = json_decode($request['json']);
$deleted = $json->deleted;
$newbom = new Product_Model_Newbom();
$fadev = new Product_Model_Fadev();
$sondev = new Product_Model_Sondev();
$fa = new Product_Model_Fa();
$son = new Product_Model_Son();
$record = new Dcc_Model_Record();
$review = new Dcc_Model_Review();
if (count($deleted) > 0) {
foreach ($deleted as $val) {
$id = $val->id;
// 操作记录
$data = array('type' => "bom", 'table_name' => "oa_product_bom_new", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "删除", 'ip' => $_SERVER['REMOTE_ADDR']);
// 获取bom fa表的recordkey
$sql = "select recordkey from oa_product_bom_fa_dev where nid={$id} and (type='new')";
$keys = $fa->getAdapter()->query($sql)->fetchObject();
if ($keys && $keys->recordkey) {
$recordkey = $keys->recordkey;
} else {
$sql = "select recordkey from oa_product_bom_fa where nid={$id} and (type='new')";
$keys = $fa->getAdapter()->query($sql)->fetchObject();
if ($keys && $keys->recordkey) {
$recordkey = $keys->recordkey;
}
}
try {
// 增加record记录
$record->insert($data);
// 删除review记录
$review->delete("type = 'bom' and file_id = {$id}");
// 删除bom表
$newbom->delete("id = {$id}");
if (isset($recordkey) && $recordkey) {
$where = "recordkey = {$recordkey}";
$fadev->delete($where);
$sondev->delete($where);
$fa->delete($where);
$son->delete($where);
}
} catch (Exception $e) {
$result['result'] = false;
$result['info'] = $e->getMessage();
echo Zend_Json::encode($result);
exit;
}
}
}
echo Zend_Json::encode($result);
exit;
}
