public function add($inp_all, $sites_id, $add_ghimat)
{
$my = new mysql_class();
$tmp = '';
parvaz_det_tmp_class::disable_parvaz_det($sites_id);
$okDets = array();
foreach ($inp_all as $inp) {
$parvaz_id = $inp['parvaz'];
$tarikh = $inp['date'];
$saat = $inp['saat'];
$zarfiat = (int) $inp['tedad'];
$ghimat = $inp['ghimat'] + $add_ghimat;
$my->ex_sql("select id,ghimat,zarfiat,en from parvaz_det where parvaz_id={$parvaz_id} and DATE(tarikh) = '{$tarikh}'", $q);
//$my->ex_sql("select id,ghimat,zarfiat,en from parvaz_det where parvaz_id=$parvaz_id and tarikh='$tarikh' and saat='$saat' ",$q);
if (isset($q[0])) {
if ((int) $q[0]['en'] != 0) {
$r = $q[0];
if ((int) $r['ghimat'] > $ghimat || ((int) $r['ghimat'] == $ghimat and $zarfiat != (int) $r['zarfiat']) || (int) $r['en'] == 3) {
$my->ex_sqlx("delete from parvaz_det where id=" . $r['id']);
$my->ex_sqlx("insert into parvaz_det (id,parvaz_id,tarikh,saat,zarfiat,ghimat,typ,toz,en) values (" . $r['id'] . ",'{$parvaz_id}','{$tarikh}','{$saat}','{$zarfiat}','{$ghimat}','0',''," . ((int) $q[0]['en'] == 3 ? 1 : $q[0]['en']) . ")");
$my->ex_sqlx("update parvaz_det_sites set sites_id={$sites_id} where parvaz_det_id =" . $r['id']);
}
}
$okDets[] = (int) $r['id'];
} else {
$ln = $my->ex_sqlx("insert into parvaz_det (parvaz_id,tarikh,saat,zarfiat,ghimat,typ) values ('{$parvaz_id}','{$tarikh}','{$saat}','{$zarfiat}','{$ghimat}','0')", FALSE);
$id_inp = (int) $my->insert_id($ln);
$my->close($ln);
if ($id_inp > 0) {
$okDets[] = (int) $id_inp;
$my->ex_sqlx("insert into parvaz_det_sites (parvaz_det_id,sites_id) values ({$id_inp},{$sites_id}) ");
}
}
}
$my->ex_sqlx("update parvaz_det set en=3 where id in (select parvaz_det_id from parvaz_det_sites where sites_id = {$sites_id}) " . (count($okDets) > 0 ? 'and not id in (' . implode(',', $okDets) . ')' : ''));
}
include $path . 'class' . DIRECTORY_SEPARATOR . 'mysql_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'audit_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'c_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'shahr_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'parvaz_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'parvaz_det_tmp_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'sites_class.php';
include $path . 'class' . DIRECTORY_SEPARATOR . 'havapeima_class.php';
include $path . 'jdf.php';
//-----------------------------------------------------------------------------
$forbidden_colors = array(7 => array('#CCFFCC'));
$sites = sites_class::load();
foreach ($sites as $i => $site) {
$c = new c_class($site['url']);
$c->forbidden_colors = isset($forbidden_colors[(int) $site['id']]) ? $forbidden_colors[(int) $site['id']] : array();
//echo "data from '".$site['url']."'\n";
$inp = $c->findFlights((int) $site['is_old'] > 0 ? 2 : 0);
//var_dump($inp);
//var_dump($inp);
parvaz_det_tmp_class::add($inp, $site['id'], $site['ghimat']);
}
/*
$inp=array();
$inp[] = array('date'=>"2014-5-19","saat"=>"23:59","tedad"=>"9","ghimat"=>1200000,"karmozd"=>"0","parvaz"=>28,"tozihat"=>"");
$inp[] = array('date'=>"2014-5-18","saat"=>"15:30","tedad"=>"4","ghimat"=>900000,"karmozd"=>"3","parvaz"=>30,"tozihat"=>"ندارد");
parvaz_det_tmp_class::add($inp,2,0);
$inp=array();
$inp[] = array('date'=>"2014-5-18","saat"=>"15:10","tedad"=>"6","ghimat"=>900000,"karmozd"=>"2","parvaz"=>30,"tozihat"=>"ﻥﺩﺍﺭﺩ");
$inp[] = array('date'=>"2014-5-18","saat"=>"15:10","tedad"=>"6","ghimat"=>900000,"karmozd"=>"2","parvaz"=>31,"tozihat"=>"ﻥﺩﺍﺭﺩ");
parvaz_det_tmp_class::add($inp,1,0);
*/