public function getcodeverAction() { $request = $this->getRequest()->getParams(); $fa = new Product_Model_Fadev(); $son = new Product_Model_Son(); $db = $fa->getAdapter(); $code = $request['code']; $result = array(""); if ($code) { $where = "code = '{$code}'"; $data = $fa->getJoinList($where, array(), array('id' => 'ver', 'text' => 'ver'), array('ver desc')); if ($data && count($data) > 0) { $result = $data; } } // 将类别数据转为json格式并输出 echo Zend_Json::encode($result); exit; }
/** * @abstract 作废 * @return null */ public function obsoleteAction() { // 返回值数组 $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(); $fadev = new Product_Model_Fadev(); $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表 $udata = array('state' => 'Obsolete'); $fa->update($udata, "sid = {$id}"); $fadev->update($udata, "recordkey = {$recordkey}"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } echo Zend_Json::encode($result); exit; }
public function removeexistsAction() { $return = array("success" => true, "info" => ""); $result = $this->getRequest()->getParams(); if (isset($result['nid']) && $result['nid']) { $nid = $result['nid']; $type = $result['type']; $fadev = new Product_Model_Fadev(); $sondev = new Product_Model_Sondev(); $data = $fadev->getFaList("nid={$nid} and type='{$type}'"); $keys = array(); foreach ($data as $row) { $keys[] = $row['recordkey']; } $fadev->delete("nid={$nid} and type='{$type}'"); $sondev->delete("recordkey in (" . implode(',', $keys) . ")"); } else { $return['success'] = false; $return['info'] = "没有获取到ID,请刷新页面再重试"; } // 转为json格式并输出 echo Zend_Json::encode($return); 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; }