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