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;
}
}
