public function actionMb()
{
$day = date("l", time());
$data = Calendar::model()->find("thu = :thu", array(":thu" => $day));
$nam = explode(",", $data->nam);
$trung = explode(",", $data->trung);
$bac = explode(",", $data->bac);
$url = 'http://minhngoc.net.vn/xstt/MB/MB.php?visit=0';
$content = file_get_contents($url);
$arr = explode(";", $content);
$ret = array();
foreach ($arr as $item) {
$tmp = explode('=', $item);
$key = $tmp[0];
$key = str_replace('kqxs["', '', $key);
$key = str_replace('"]', '', $key);
$key = str_replace("\r\n", '', $key);
$value = end($tmp);
$value = str_replace('"', '', $value);
$value = preg_replace('/[^0-9]/', '', $value);
$ret[$key] = $value;
}
if (date("d-m-Y", $ret["newtime"]) == date("d-m-Y", time())) {
$tinh = explode(",", $ret["listtinhnew"]);
$date = date("d-m-Y", time());
foreach ($bac as $province) {
$pro = CommonHelper::maprev($province);
unset($ret["\r\nT" . $pro . "_LV"]);
unset($ret["\r\n"]);
$proexist = KqxsBac::model()->find("date=:date and provice=:provice", array(":date" => $date, ":provice" => $province));
if (!$proexist) {
$model = new KqxsBac();
$model->date = $date;
$model->provice = $province;
$model->db = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_Gdb"]);
$model->nhat = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G1"]);
$model->nhi1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G2_1"]);
$model->nhi2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G2_2"]);
$model->ba1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_1"]);
$model->ba2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_2"]);
$model->ba3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_3"]);
$model->ba4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_4"]);
$model->ba5 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_5"]);
$model->ba6 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_6"]);
$model->tu1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_1"]);
$model->tu2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_2"]);
$model->tu3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_3"]);
$model->tu4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_4"]);
$model->nam1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_1"]);
$model->nam2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_2"]);
$model->nam3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_3"]);
$model->nam4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_4"]);
$model->nam5 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_5"]);
$model->nam6 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_6"]);
$model->sau1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_1"]);
$model->sau2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_2"]);
$model->sau3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_3"]);
$model->bay1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_1"]);
$model->bay2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_2"]);
$model->bay3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_3"]);
$model->bay4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_4"]);
$model->insert();
} else {
$proexist->db = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_Gdb"]);
$proexist->nhat = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G1"]);
$proexist->nhi1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G2_1"]);
$proexist->nhi2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G2_2"]);
$proexist->ba1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_1"]);
$proexist->ba2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_2"]);
$proexist->ba3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_3"]);
$proexist->ba4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_4"]);
$proexist->ba5 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_5"]);
$proexist->ba6 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G3_6"]);
$proexist->tu1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_1"]);
$proexist->tu2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_2"]);
$proexist->tu3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_3"]);
$proexist->tu4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G4_4"]);
$proexist->nam1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_1"]);
$proexist->nam2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_2"]);
$proexist->nam3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_3"]);
$proexist->nam4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_4"]);
$proexist->nam5 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_5"]);
$proexist->nam6 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G5_6"]);
$proexist->sau1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_1"]);
$proexist->sau2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_2"]);
$proexist->sau3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G6_3"]);
$proexist->bay1 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_1"]);
$proexist->bay2 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_2"]);
$proexist->bay3 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_3"]);
$proexist->bay4 = preg_replace('/[^A-Za-z0-9]/', '', $ret["T" . $pro . "_G7_4"]);
$proexist->update();
}
}
}
$this->renderJSON($ret);
}
