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