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');
}
function act_getStandardInfo()
{
$id = $_POST['id'];
$list = SampleStandardModel::getNowStandardList("sName", "where sampleTypeId='{$id}' group by sName");
if ($list) {
return $list;
} else {
self::$errCode = CategoryModel::$errCode;
self::$errMsg = CategoryModel::$errMsg;
return false;
}
}
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;
}
public static function getSampleStandardNum($where)
{
self::initDB();
$sql = "select * from " . self::$table . " {$where}";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->num_rows($query);
return $ret;
//成功， 返回列表数据
} else {
self::$errCode = "003";
self::$errMsg = "444444444";
return false;
//失败则设置错误码和错误信息， 返回false
}
}
