Пример #1
0
 public function getlistAction()
 {
     $review = new Dcc_Model_Review();
     $user_session = new Zend_Session_Namespace('user');
     $user = $user_session->user_info['employee_id'];
     // 清理无效数据
     $where1 = " type='files' and file_id in (select id from oa_doc_files where state = 'Return' or state = 'Delete')";
     $review->delete($where1);
     $where2 = " type='materiel' and file_id in (select id from oa_product_materiel where state = 'Return' or state = 'Delete')";
     $review->delete($where2);
     $where3 = " type='bom' and file_id in (select id from oa_product_bom_new where state = 'Return' or state = 'Delete')";
     $review->delete($where3);
     $where4 = " type='devbom' and file_id in (select id from oa_product_bom_upd where state = 'Return' or state = 'Delete')";
     $review->delete($where4);
     $where5 = " type='ecobom' and file_id in (select id from oa_product_bom_upd where state = 'Return' or state = 'Delete')";
     $review->delete($where5);
     $where6 = " type='materiel_desc' and file_id in (select id from oa_product_materiel_desc where state = 'Return' or state = 'Delete')";
     $review->delete($where6);
     $data = $review->getBacklogList($user);
     $updcount = 0;
     for ($i = 0; $i < count($data); $i++) {
         if ($data[$i]['type'] == 'devbom') {
             $updcount += $data[$i]['count'];
         } else {
             if ($data[$i]['type'] == 'ecobom') {
                 $updcount += $data[$i]['count'];
             } else {
                 if ($data[$i]['type'] == 'updbom') {
                     $updcount += $data[$i]['count'];
                 }
             }
         }
     }
     $result = array();
     for ($i = 0; $i < count($data); $i++) {
         if ($data[$i]['type'] != 'devbom' && $data[$i]['type'] != 'ecobom' && $data[$i]['type'] != 'updbom') {
             $result[] = $data[$i];
         }
     }
     if ($updcount > 0) {
         $result[] = array("count" => $updcount, "type" => "updbom");
     }
     echo Zend_Json::encode($result);
     exit;
 }