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; }
function act_sampleSizeEditSubmit($where) { //调用model层获取数据 $qcStandardModel = new qcStandardModel(); $list = $qcStandardModel->sampleSizeEditSubmit($where); if ($list) { return true; } else { return false; } }
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; } }