function act_getTypeInfo() { $cate = $_POST['cate']; $num = $_POST['num']; $sku = $_POST['sku']; $where = "where sampleTypeId='{$cate}' and minimumLimit<='{$num}' and maximumLimit>='{$num}' limit 1"; $list = DetectStandardModel::getNowStandardList("*", $where); if ($list) { $list[0]['sku'] = get_sku_imgName($sku); return $list; } else { self::$errCode = "003"; self::$errMsg = "未找到该类别的检测标准!"; return false; } }
public function view_openSampleType() { $standard_arr = array(); $sampleType = DetectStandardModel::getSampleTypeList("*", "where 1"); $this->smarty->assign('sampleType', $sampleType); $sampleStandardList = SampleStandardModel::getNowStandardList("*", "group by sName,sampleTypeId"); foreach ($sampleStandardList as $sample) { $standard_arr[$sample['sampleTypeId']][] = array('sName' => $sample['sName'], 'is_open' => $sample['is_open']); } $this->smarty->assign('standard_arr', $standard_arr); $this->smarty->assign('secnev', '4'); //二级导航 $this->smarty->assign('module', '开启检测样本标准'); $this->smarty->assign('username', $_SESSION['userName']); $navarr = array("<a href='index.php?mod=nowSampleStandard&act=sampleStandardList'>检测样本标准</a>", ">>", "开启检测样本标准"); $this->smarty->assign('navarr', $navarr); $this->smarty->display('sampleStandardOpen.html'); }
public function view_onSampleCoefficient() { if (!isset($_SESSION['userId'])) { //检测用户是否登陆 header('location:index.php?mod=login&act=index'); exit; } $sampleCoefficientAct = new SampleCoefficientAct(); $sampleTypeOnId = isset($_GET['sampleTypeOnId']) ? post_check($_GET['sampleTypeOnId']) : ''; $cNameOn = isset($_GET['cNameOn']) ? post_check($_GET['cNameOn']) : ''; if (empty($sampleTypeOnId) || empty($cNameOn)) { //为空时,跳转到列表页面,输出错误信息 $status = '启动失败,id为空'; header("location:index.php?mod=sampleCoefficient&act=getSampleCoefficientList&status={$status}"); exit; } $return = $sampleCoefficientAct->act_onSampleCoefficient($cNameOn, $sampleTypeOnId); //启动该系数 if ($return) { $flag = DetectStandardModel::updateSampleStandard(); if ($flag) { $status = '启动成功,检测标准已自动更新'; } else { $status = '启动成功,自动更新失败'; } } else { $status = '找不到指定记录或已经启动'; } header("location:index.php?mod=sampleCoefficient&act=getSampleCoefficientList&status={$status}"); }
function act_getnowStandard() { $update = DetectStandardModel::updateSampleStandard(); if ($update) { return true; } else { self::$errCode = "003"; self::$errMsg = ""; return false; } }
public static function updateSampleStandard() { self::initDB(); self::delete('where 1'); $sql = "select a.minimumLimit,a.maximumLimit,a.sampleTypeId,b.sampleNum,c.Ac,c.Re,c.Al,c.Rt\n\t\t\t\tfrom qc_sample_standard as a left join qc_sample_size_code as b on a.sizeCodeId=b.id\n\t\t\t\tleft join qc_sample_coefficient as c on a.sampleTypeId=c.sampleTypeId and b.id=c.sizeCodeId\n\t\t\t\twhere a.is_open=1 and c.is_open=1"; $query = self::$dbConn->query($sql); if ($query) { $result = self::$dbConn->fetch_array_all($query); foreach ($result as $res) { $data = array(); $data = array('sampleTypeId' => $res['sampleTypeId'], 'minimumLimit' => $res['minimumLimit'], 'maximumLimit' => $res['maximumLimit'], 'sampleNum' => $res['sampleNum'], 'Ac' => $res['Ac'], 'Re' => $res['Re'], 'Al' => $res['Al'], 'Rt' => $res['Rt']); self::insertRow($data); } return true; } else { self::$errCode = "003"; self::$errMsg = "error"; return false; } }