/** * @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; $updbom = new Product_Model_Updbom(); $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; $upd_type = $val->upd_type; if ($upd_type == 'ECO') { $bomflg = "ecobom"; $table = "oa_product_bom_eco"; } else { if ($upd_type == 'DEV') { $bomflg = "devbom"; $table = "oa_product_bom_dev"; } } // 操作记录 $data = array('type' => $bomflg, 'table_name' => $table, '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='DEV' or type='ECO')"; $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='DEV' or type='ECO')"; $keys = $fa->getAdapter()->query($sql)->fetchObject(); if ($keys && $keys->recordkey) { $recordkey = $keys->recordkey; } } try { // 增加record记录 $record->insert($data); // 删除review记录 $review->delete("type = '{$bomflg}' and file_id = {$id}"); // 删除bom表 $updbom->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; }
/** * @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(); $fa = new Product_Model_Fa(); $son = new Product_Model_Son(); $fadev = new Product_Model_Fadev(); $sondev = new Product_Model_Sondev(); $record = new Dcc_Model_Record(); $review = new Dcc_Model_Review(); if (count($deleted) > 0) { foreach ($deleted as $val) { $id = $val->sid; $recordkey = $val->recordkey; // 操作记录 $data = array('type' => "bom", 'table_name' => "oa_product_bom_new", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "删除", 'ip' => $_SERVER['REMOTE_ADDR']); try { // 增加record记录 $record->insert($data); // 删除bom表 $fa->delete("sid = {$id}"); $son->delete("recordkey = {$recordkey}"); if ($val->nid) { $fadev->delete("recordkey = {$recordkey}"); $sondev->delete("recordkey = {$recordkey}"); } } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } echo Zend_Json::encode($result); exit; }