function act_getSampleTypeName($path)
 {
     $reDataArr = array();
     $whereStr = " where path = '{$path}' AND is_delete != 1 ";
     $selectStr = "`path`,`sampleTypeId`";
     $sampleTypeIdArr = qcCategoryListModel::getCategoryList($selectStr, $whereStr);
     if (empty($sampleTypeIdArr)) {
         return false;
     }
     $whereStr2 = " where id = {$sampleTypeIdArr[0]['sampleTypeId']} ";
     $qcStandardModel = new qcStandardModel();
     $listArr = $qcStandardModel->skuTypeQcList($whereStr2);
     if (empty($listArr)) {
         return false;
     } else {
         $reDataArr[$sampleTypeIdArr[0]['sampleTypeId']] = $listArr[0]['typeName'] . "-" . $listArr[0]['describe'];
         return $reDataArr;
     }
 }
 function act_addNameToList($arr)
 {
     //将参数数组分别添加相应id对应的名称
     for ($i = 0; i < count($arr); $i++) {
         $where = "WHERE id='{$arr[$i]['sampleTypeId']}'";
         $sampleTypeNameList = qcStandardModel::skuTypeQcList($where);
         $arr[$i]['sampleTypeName'] = $sampleTypeNameList[0]['typeName'];
     }
     for ($i = 0; i < count($arr); $i++) {
         $select = 'sampleNum';
         $where = "WHERE id='{$arr[$i]['sizeCodeId']}' ";
         $sizeCodeNumList = SampleStandardModel::getSampleSizeCodeList($select, $where);
         $arr[$i]['sizeCodeNum'] = $sizeCodeNumList[0]['sampleNum'];
     }
     return $arr;
 }
Exemple #3
0
 function act_sampleSizeEditSubmit($where)
 {
     //调用model层获取数据
     $qcStandardModel = new qcStandardModel();
     $list = $qcStandardModel->sampleSizeEditSubmit($where);
     if ($list) {
         return true;
     } else {
         return false;
     }
 }
Exemple #4
0
 public function detectionTypeList($where)
 {
     $info = array();
     $sql = "select * from qc_sample_detection_type {$where}";
     $query = $this->dbconn->query($sql);
     if ($query) {
         $info = $this->dbconn->fetch_array_all($query);
         return $info;
     } else {
         self::$errCode = "003";
         self::$errMsg = "IQC检测类型显示SQL语句错误!";
         return false;
     }
 }