foreach ($_FILES as $file_name => $file_array) {
//if a file is chosen
if (isset($_POST["file"])) {
#eval("echo \"".$tpl->getTemplate("CsvImport/csvImportWarning")."\";");
}
if (is_uploaded_file($file_array['tmp_name'])) {
//open file
$fp = fopen($file_array['tmp_name'], "r");
//open selected parser
require_once BADGER_ROOT . "/modules/csvImport/parser/" . getGPC($_POST, 'parserSelect');
//save last used parser
$accountId = getGPC($_POST, 'accountSelect', 'integer');
//save last used account
$us->setProperty("csvImportStandardAccount", $accountId);
//call to parse function
$foundTransactions = parseToArray($fp, $accountId);
//delete existing transactions, criteria are accountid, date & amount
$LookupTransactionNumber = count($foundTransactions);
$filteredTransactions = 0;
$importedTransactionNumber = 0;
$importedTransactions = NULL;
//for every transaction received from the parser
for ($foundTransactionNumber = 0; $foundTransactionNumber < $LookupTransactionNumber; $foundTransactionNumber++) {
$am4 = new AccountManager($badgerDb);
$account4 = $am4->getAccountById($foundTransactions[$foundTransactionNumber]["accountId"]);
//set filter to read existing transactions from database
$account4->setFilter(array(array('key' => 'valutaDate', 'op' => 'eq', 'val' => $foundTransactions[$foundTransactionNumber]["valutaDate"]), array('key' => 'amount', 'op' => 'eq', 'val' => $foundTransactions[$foundTransactionNumber]["amount"])));
//if there is a transaction with same amount & valutaDate in the database
if ($existing = $account4->getNextFinishedTransaction()) {
$filteredTransactions++;
} else {
while ($row = @mysqli_fetch_array($packs)) {
$stats = mysqli_query($con, "select count(*) from status where id_pack='" . $row['id_pack'] . "'");
//echo ("select count(*) from status where id_pack='".$row['id_pack']."'");
$row2 = @mysqli_fetch_array($stats);
//var_dump($row2);
$dom = new DomDocument();
$web_page = @file_get_contents("http://gdeposylka.ru/" . $row[id_pack]);
//echo ("http://gdeposylka.ru/".$_POST["track"]);
$web_page = mb_convert_encoding($web_page, 'HTML-ENTITIES', 'UTF-8');
@$dom->loadHTML($web_page);
$xpath = new DOMXpath($dom);
$office = parseToArray($xpath, 'city');
$c_office = count($office);
$date = parseToArray($xpath, 'parcelin-date parcelin-received-date');
$c_date = count($date);
$status = parseToArray($xpath, 'parcelin-status');
$c_status = count($status);
if ($c_office > $row2["count(*)"]) {
//echo $c_office;
//var_dump($c_office);
//var_dump($row2["count(*)"]);
$filter = mysqli_query($con, "delete from status where id_pack='" . $row[id_pack] . "'");
//echo "delete from status where id_pack='".$row[id_pack]."'";
$filter = mysqli_query($con, "insert into status (id_pack,id_office,id_stat_dict,date_time_change) values ('" . $row[id_pack] . "','" . $office[0] . "','" . $status[0] . "','" . $date[0] . "')");
$mail = new PHPMailer();
//$mail->SMTPDebug = 3; // Enable verbose debug output
$mail->CharSet = 'UTF-8';
//Set charset
$mail->isSMTP();
// Set mailer to use SMTP
$mail->Host = "smtp.gmail.com";
