PHP 4 to PHP 5
| From: | De vries | Date: | Thu, 27 Aug 2009 13:28:25 +0000 |
| Subject: | PHP 4 to PHP 5 | ||
| Groups: | php.webmaster | ||
| Request: | Send a blank email to php-webmaster+get-5739@lists.php.net to get a copy of this message | ||
Hello webmasters of php.net,
I have an big problem we upgraded php4 to php5 but then out cms has gotten a problem with loading.
It takes around 60 seconds before the page is finally is there.
I attached the php file which has the error to this mail.
I hope you could help me with it.
Yours sincerely,
Pascal H.
<?php defined('IN_KERNEL') or die('Aanvraag geweigerd'); global $cms, $perpagina; $cms->assignGlobal('PATHWAY', sprintf('<a href="%s/admin/index.php?module=main">Hoofdpagina</a> > <a href="%s/admin/index.php?module=%s">Orderverwerking</a>', BASE_DIR, BASE_DIR, $_GET['module'])); switch($_GET['sub']) { case 14: // vestuur de enquetes $sub = 'verstuur_enquete'; break; case 13: // vestuur de betalingsherinneringen $sub = 'verstuur_betalings_herinneringen'; break; case 12: // order acties (verwijderen, verplaatsen) $sub = 'order_acties'; break; case 11: // Check en verwerk barcode scan $sub = 'barcode'; break; case 10: // Verstuur "Order vandaag verzonden" e-mail berichten $sub = 'email_vandaag_verzonden'; break; case 9: // Naar archief $sub = 'naar_archief'; break; case 8: // Bestelling verzonden $sub = 'bestelling_verzonden'; break; case 7: // Betaling gecontroleerd en akkoord $sub = 'gecontroleerd_akkoord'; break; case 6: // Betaald, gecontroleerd, verzonden, print etiket $sub = 'status_all'; break; case 5: // Klant gegevens wijzigen $sub = 'wijzig_gegevens'; $filename = 'wijzig_gegevens.tpl'; break; case 4: // show order $sub = 'order'; $filename = 'order.tpl'; break; case 3: // zoeken $sub = 'zoeken'; $filename = 'zoeken.tpl'; break; case 2: // archief $sub = 'archief'; $filename = 'order_archief.tpl'; break; case 1: default: $sub = 'index'; $filename = 'index.tpl'; /** * Verplaats order ouder dan 2 weken naar het archief */ verlopenNaarArchief(); break; } if(isset($filename) && $filename != '') { $module = new TemplatePower(sprintf('modules/%s/templates/%s', $_GET['module'], $filename)); $module->prepare(); } /** * Overzicht van alle openstaande orders */ if($sub == 'index') { $page_title = 'Overzicht orders'; /** * Vandaag verzonden */ $vandaagTimestamp1 = mktime( 0, 0, 0, date( 'n, j, Y' ) ); $vandaagTimestamp2 = mktime( 23, 59, 59, date( 'n, j, Y' ) ); $sql = sprintf( 'SELECT * FROM %s WHERE verzendstatus = "1" AND verzendEmailVerzonden = "0" AND verzendstatusTimestamp >= %d AND verzendstatusTimestamp <= %d', TABLE_BESTELLINGEN, $vandaagTimestamp1, $vandaagTimestamp2 ); $result = sql_query($sql); $orderBetaaldVandaag = mysql_num_rows( $result ); $module->assignGlobal( 'VANDAAG_VERSTUURD', $orderBetaaldVandaag ); /** * Betalingsherinneringen */ $eenWeek = 604800; $tweeWeken = 1209600; $eenWeekGeleden = time() - $eenWeek; $tweeWekenGeleden = time() - $tweeWeken; $woensdag_5_maart = mktime(13, 0, 0, 3, 5, 2008); // timestamp: 5 maart 2008 13.00 uur $sql = 'SELECT be.*, be.id AS bestelling_id, account.*, naw.* FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id INNER JOIN %s AS naw ON be.account_id = naw.account_id WHERE be.archief = "0" AND be.betaalstatus = "0" AND be.verzendstatus = "0" AND be.herinneringVerstuurd = "0" AND be.timestamp < %d AND be.timestamp > %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, TABLE_NAW, $eenWeekGeleden, $tweeWekenGeleden); $result = sql_query($sql); $betalings_herinneringen = mysql_num_rows( $result ); $module->assignGlobal( 'BETALINGS_HERINNERINGEN', $betalings_herinneringen); /** * Enquetes */ $enquetePeriodeMin = 2592000; // = 30 dagen $enquetePeriodeMax = 3196800; // = 37 dagen $periode1 = time() - $enquetePeriodeMin; $periode2 = time() - $enquetePeriodeMax; $sql = 'SELECT be.id AS bestelling_id, be.verzendstatusTimestamp, be.ordernr, be.bestel_land, be.bankId, account.id AS account_id, account.email, naw.aanhef, naw.tussenvoegsel, naw.achternaam FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id INNER JOIN %s AS naw ON be.account_id = naw.account_id WHERE betaalstatus = "1" AND verzendstatus = "1" AND enqueteVerstuurd = "0" AND verzendstatusTimestamp < %d AND verzendstatusTimestamp > %d ORDER BY verzendstatusTimestamp ASC'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, TABLE_NAW, $periode1, $periode2); $result = sql_query($sql); $enquetes = mysql_num_rows($result); $module->assignGlobal( 'ENQUETES', $enquetes); /** * Overzicht ophalen */ if($_GET['page'] > 0) $start = $_GET['page'] * 20; else $start = 0; $sql = 'SELECT be.*, ba.naam AS banknaam FROM %s AS be INNER JOIN %s AS ba ON be.bankId = ba.id WHERE be.archief = "0" ORDER BY be.datumtijd DESC LIMIT %d, %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_BANKEN, $start, $perpagina); $result = sql_query($sql) or die(mysql_error()); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW !!! $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('ORDER_ROW'); $module->assign('ORDER_ROW.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('ORDER_ROW.ID', $row['id']); $module->assign('ORDER_ROW.ORDERNR', $row['ordernr']); $module->assign('ORDER_ROW.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('ORDER_ROW.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('ORDER_ROW.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('ORDER_ROW.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('ORDER_ROW.KLANTNR', $row['account_id']); $module->assign('ORDER_ROW.EMAIL', $row4['email']); $module->assign('ORDER_ROW.PLAATS', $row3['plaats']); $module->assign('ORDER_ROW.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('ORDER_ROW.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } /** * Build navigation * getNav() * int archief (0/1, 0 = archief) * string module () * int sub (module sub) */ $module->assignGlobal('NAV', getNav(0, $_GET['module'], 1)); } /** * Order archief */ if($sub == 'archief') { $page_title = 'Order archief'; if($_GET['page'] > 0) $start = $_GET['page'] * 20; else $start = 0; $sql = 'SELECT be.*, ba.naam AS banknaam FROM %s AS be INNER JOIN %s AS ba ON be.bankId = ba.id WHERE be.archief = "1" ORDER BY be.datumtijd DESC LIMIT %d, %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_BANKEN, $start, $perpagina); $result = sql_query($sql) or die(mysql_error()); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW !!! $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('ORDER_ROW'); $module->assign('ORDER_ROW.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('ORDER_ROW.ID', $row['id']); $module->assign('ORDER_ROW.ORDERNR', $row['ordernr']); $module->assign('ORDER_ROW.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('ORDER_ROW.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('ORDER_ROW.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('ORDER_ROW.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('ORDER_ROW.KLANTNR', $row['account_id']); $module->assign('ORDER_ROW.EMAIL', $row4['email']); $module->assign('ORDER_ROW.PLAATS', $row3['plaats']); $module->assign('ORDER_ROW.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('ORDER_ROW.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } /** * Build navigation * getNav() * int archief (0/1, 0 = archief) * string module () * int sub (module sub) */ $module->assignGlobal('NAV', getNav(1, $_GET['module'], 2)); } /** * Zoeken */ if($sub == 'zoeken') { /** * Omdat er is het oude systeem NAW gegevens aan een acount waren gekoppeld * en in het nieuwe systeem de NAW gegeven gekoppels zijn aan de bestelling * is alles per zoekfuntie geprogrammeerd. * * Bij een mindere deadline kunnen we dit eens herzien. * */ $module->assign('START_PERIODE',date("d-m-Y",time()-86400)); $module->assign('END_PERIODE',date("d-m-Y",time())); if($_SERVER['REQUEST_METHOD'] == 'POST') { $page_title = 'Zoeken - resultaten'; $module->assignGlobal('QUERY', $_POST['query']); if(strlen($_POST['search_string']) == 0 && strlen($_POST['start_periode']) == 0 && strlen($_POST['eind_periode']) == 0) { $module->newblock('NO_QUERY'); } else { $module->assign('SEARCH_STRING', $_POST['search_string']); /** * SEARCH: Ordernummer */ if($_POST['search_category'] == 'ordernummer') { $module->assign('SEARCH_ORDERNUMMER', "selected='selected'"); $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.ordernr LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_ORDERNUMBER'); } } /** * SEARCH: klantnummer */ if($_POST['search_category'] == 'klantnummer') { $module->assign('SEARCH_KLANTNUMMER', "selected='selected'"); $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = '" .$_POST['search_string']. "' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_KLANTNUMBER'); } } /** * SEARCH: betaalwijze */ if($_POST['search_category'] == 'betaalwijze') { $module->assign('SEARCH_BETAALWIJZE', "selected='selected'"); $module->assign('START_PERIODE',$_POST['start_periode']); $module->assign('END_PERIODE',$_POST['end_periode']); $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BA.naam LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_BETAALWIJZE'); } } /** * SEARCH: klantnaam */ if($_POST['search_category'] == 'klantnaam') { $module->assign('SEARCH_KLANTNAAM', "selected='selected'"); $sql = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, cms_mod_members_naw MN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = MN.account_id AND MN.achternaam LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; $sql2 = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BESTELLINGEN_NAW." BN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.id = BN.bestelling_id AND BN.achternaam LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); $result2 = sql_query($sql2) or die(mysql_error()); if(sql_numrows($result) > 0 || sql_numrows($result2) > 0) { $module->newblock('WE_HAVE_RESULTS'); $ordernr_array = array(); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } $i = 0; while($row2 = sql_fetchrow($result2)) { if ( !in_array($row2['ordernr'],$ordernr_array)){ $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } else $i = $i+1; } $otherQuery = sql_numrows($result2)-$i; } else { $module->newblock('NO_RESULTS_KLANTNAAM'); } } /** * SEARCH: periode */ if($_POST['search_category'] == 'periode') { $module->assign('SEARCH_PERIODE', "selected='selected'"); $module->assign('START_PERIODE', $_POST['start_periode']); $module->assign('END_PERIODE', $_POST['eind_periode']); $module->newblock('SHOWPERIODE'); /** * Change the dates to timestamps */ $start_periode = explode('-',$_POST['start_periode']); $start_periode = mktime(0, 0, 0, $start_periode[1], $start_periode[0], $start_periode[2]); $end_periode = explode('-',$_POST['eind_periode']); $end_periode = mktime(0, 0, 0, $end_periode[1], $end_periode[0], $end_periode[2])+86400; //add one day $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.timestamp < '".$end_periode."' AND BE.timestamp > '".$start_periode."' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_PERIODE'); } } /** * SEARCH: email */ if($_POST['search_category'] == 'email') { $module->assign('SEARCH_EMAIL', "selected='selected'"); $sql = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, cms_mod_members_accounts MN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = MN.id AND MN.email LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); $ordernr_array = array(); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_EMAIL'); } } /** * SEARCH: Plaats */ if($_POST['search_category'] == 'plaats') { $module->assign('SEARCH_PLAATS', "selected='selected'"); $sql = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, cms_mod_members_naw MN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = MN.id AND MN.plaats LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); $ordernr_array = array(); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_PLAATS'); } } } $page_title .= sprintf(' (%s)', ($result) ? sql_numrows($result)+$otherQuery : 0); } else { $page_title = 'Zoeken'; } } /** * Show order */ if($sub == 'order') { $page_title = ''; if($_GET['id'] > 0) { $sql = 'SELECT be.*, be.id AS orderid, be.account_id AS klantid, naw.*, bank.naam AS banknaam, account.email FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id INNER JOIN %s AS naw ON be.account_id = naw.account_id INNER JOIN %s AS bank ON be.bankId = bank.id WHERE be.id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, TABLE_NAW, TABLE_BANKEN, $_GET['id']); $result = sql_query($sql); if(sql_numrows($result) > 0) { $row = sql_fetchrow($result); /** * Disable links if needed */ if($row['betaalstatus'] == 1 && $row['verzendstatus'] == 1) { $module->assignGlobal('CHECKALL_DISABLED', ' disabled="disabled"'); $module->assignGlobal('LINK_ONCLICK', 'return false;'); $module->assignGlobal('BOX_CHECKED', ' checked="checked"'); } if($row['betaalstatus'] == 1) { $module->assignGlobal('BETAALD_CHECKED', ' checked="checked"'); $module->assignGlobal('BETAALD_DISABLED', ' disabled="disabled"'); } if($row['verzendstatus'] == 1) { $module->assignGlobal('VERZONDEN_CHECKED', ' checked="checked"'); $module->assignGlobal('VERZONDEN_DISABLED', ' disabled="disabled"'); } if($row['archief'] == 1) $module->assignGlobal('ARCHIEF_CHECKED', ' checked="checked"'); /** * Haal NAW gegevens op indien opgeslagen bij order, * anders account gekoppelde NAW gegevens ophalen (alleen voor orders van voor het nieuwe platform) */ $sql2 = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql2 = sprintf($sql2, TABLE_BESTELLINGEN_NAW, $row['orderid']); $result2 = sql_query($sql2); $nawFound = false; if(sql_numrows($result2) > 0) { /** * NAW gegevens (gekoppeld aan order) gevonden */ $nawFound = true; $row2 = sql_fetchrow($result2); $naam = sprintf('%s%s %s %s %s', ucfirst($row2['aanhef']), ($row2['aanhef']=='') ? null : '.', $row2['voorletters'], $row2['tussenvoegsel'], $row2['achternaam']); $adres = sprintf( '%s %s', $row2['straat'], $row2['nummer']); } else { /** * Oude order (geen NAW gegevens gekoppeld aan order gevonden) * Toon account gekoppelde NAW gegevens */ $naam = sprintf('%s%s %s %s %s', ucfirst($row['aanhef']), ($row['aanhef']=='') ? null : '.', $row['voorletters'], $row['tussenvoegsel'], $row['achternaam']); $adres = sprintf( '%s %s', $row['straat'], $row['nummer']); } $module->assignGlobal('RANDOM', rand(100000, 999999)); $module->assignGlobal('ORDERNR', $row['ordernr']); $module->assignGlobal('ORDERID', $row['orderid']); $module->assignGlobal('KLANTID', $row['klantid']); $module->assignGlobal('NAAM', $naam); $module->assignGlobal('ADRES', $adres); $module->assignGlobal('POSTCODE', ($nawFound) ? $row2['postcode'] : $row['postcode']); $module->assignGlobal('PLAATS', ($nawFound) ? $row2['plaats'] : $row['plaats']); $module->assignGlobal('LAND', ($nawFound) ? $row2['land'] : $row['land']); $module->assignGlobal('TELEFOON', ($nawFound) ? $row2['telefoon'] : $row['telefoon']); $module->assignGlobal('EMAIL', $row['email']); $module->assignGlobal('DATUMTIJD', date('d-m-Y H:i', $row['timestamp'])); $module->assignGlobal('BANK', $row['banknaam']); /** * Order action history */ if($row['timestamp'] != '') $history[$row['timestamp']] = 'order'; if($row['archief'] == 1) $history[$row['archiefTimestamp']] = 'archief'; if($row['betaalstatus'] == 1) $history[$row['betaalstatusTimestamp']] = 'bestellingBetaald'; if($row['verzendstatus'] == 1) $history[$row['verzendstatusTimestamp']] = 'bestellingVerzonden'; if($row['verzendEmailVerzonden'] == 1) $history[$row['verzendEmailVerzondenTimestamp']] = 'emailVerzonden'; if($row['herinneringVerstuurd'] == 1) $history[$row['herinneringVerstuurdTimestamp']] = 'herinneringVerzonden'; if($row['enqueteVerstuurd'] == 1) $history[$row['enqueteVerstuurdTimestamp']] = 'enqueteVerzonden'; //buildHistory($module, $history); /** * Build log */ krsort( $history ); foreach( $history as $key => $value ) { $module->newblock('ACTIELOG'); switch( $value ) { case 'order': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Order geplaatst; Factuur verstuurd per e-mail', $datumtijd ); $module->assign('ACTIELOG', $logValue); break; case 'bestellingBetaald': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Betaling gecontroleerd en akkoord', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'bestellingVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Bestelling verzonden naar klant', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'emailVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Klant per e-mail geinformeerd (verzonden)', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'herinneringVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Herinnering order per e-mail verstuurd', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'archief': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Verplaatst naar archief', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'enqueteVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Vragenformulier verzonden', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; } } /** * Inhoud van de bestelling */ $sql2 = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql2 = sprintf($sql2, TABLE_BESTELLINGEN_GEGEVENS, $_GET['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = sql_fetchrow($result2)) { $module->newblock('ARTIKEL_ROW'); $module->assign('ARTIKEL_ROW.NAAM', $row2['naam']); $module->assign('ARTIKEL_ROW.AANTAL', $row2['aantal']); $module->assign('ARTIKEL_ROW.PRIJS', number_format($row2['prijs'], 2, ',', '.')); $module->assign('ARTIKEL_ROW.TOTAAL', number_format($row2['prijs'] * $row2['aantal'], 2, ',', '.' )); $totaal += $row2['prijs'] * $row2['aantal']; } $module->assignGlobal('TOTAAL', number_format($totaal, 2, ',', '.')); /** * Verzendkosten */ $verzendkostenGrens = $row['verzendkostenGrens']; $verzendkosten = $row['verzendkosten']; if( $totaal >= $verzendkostenGrens ) $verzendkosten = 0; else $verzendkosten = $verzendkosten; /** * Rembours? */ if($row['bankId'] == 5) { $module->newblock('REMBOURS'); $module->assignGlobal('REMBOURS', '15,00'); $totaal += 15; } $totaal += $verzendkosten; $module->assignGlobal( 'BTW', number_format( $totaal - ( ( $totaal / 106 ) * 100 ), 2, ',', '.' ) ); $module->assignGlobal( 'VERZENDKOSTEN', number_format( $verzendkosten, 2, ',', '.' ) ); $module->assignGlobal( 'TOTAALBTW', number_format( $totaal, 2, ',', '.' ) ); /** * Etiket popup */ if(isset($_GET['popEt']) && $_GET['popEt'] == 'true') { $module->newblock('ETIKET_POPUP'); } } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } /** * Wijzig gegevens */ if($sub == 'wijzig_gegevens') { if($_GET['id'] > 0) { /** * Opslaan gegevens */ if($_SERVER['REQUEST_METHOD'] == 'POST') { /** * Haal adres gegevens op * Check of er NAW gegevens zijn gekoppeld aan de order, * anders de account NAW gegevens tonen */ $sql = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $_GET['id']); $result = sql_query($sql); if(sql_numrows($result) > 0) { /** * NAW gegevens (gekoppeld aan order) gevonden */ /** * Update de gegevens */ $sql = 'UPDATE %s SET '; foreach($_POST as $key => $value) $sql .= sprintf('%s = "%s", ', $key, htmlentities($value)); $sql = substr($sql, 0, -2); $sql .= ' WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $_GET['id']); sql_query($sql); } else { /** * Oude order (geen NAW gegevens gekoppeld aan order gevonden) * Insert gegevens bij order */ $sql = 'INSERT INTO %s SET bestelling_id = %d, '; foreach($_POST as $key => $value) $sql .= sprintf('%s = "%s", ', $key, $value); $sql = substr($sql, 0, -2); $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $_GET['id']); sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } $page_title = 'Klant gegevens wijzigen'; $sql = 'SELECT be.id AS bestelling_id, be.ordernr, account.id AS account_id, account.email FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id WHERE be.id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, $_GET['id']); $result = sql_query($sql); if(sql_numrows($result) == 0) redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); $row = sql_fetchrow($result); $module->assignGlobal('ORDERID', $row['bestelling_id']); $module->assignGlobal('ORDERNR', $row['ordernr']); $module->assignGlobal('EMAIL', $row['email']); /** * Haal adres gegevens op * Check of er NAW gegevens zijn gekoppeld aan de order, * anders de account NAW gegevens tonen */ $sql2 = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql2 = sprintf($sql2, TABLE_BESTELLINGEN_NAW, $row['bestelling_id']); $result2 = sql_query($sql2); if(sql_numrows($result2) > 0) { /** * NAW gegevens (gekoppeld aan order) gevonden */ $row2 = sql_fetchrow($result2); } else { /** * Oude order (geen NAW gegevens gekoppeld aan order gevonden) * Toon account gekoppelde NAW gegevens */ $sql3 = 'SELECT * FROM %s WHERE account_id = %d'; $sql3 = sprintf($sql3, TABLE_NAW, $row['account_id']); $result3 = sql_query($sql3); $row2 = sql_fetchrow($result3); $module->newblock('OLD_ORDER'); } if($row2['aanhef'] == 'dhr') $module->assignGlobal('SEL_AANHEF1', ' selected="selected"'); elseif($row2['aanhef'] == 'mevr') $module->assignGlobal('SEL_AANHEF2', ' selected="selected"'); else $module->assignGlobal('SEL_AANHEF3', ' selected="selected"'); $module->assignGlobal('VOORLETTERS', $row2['voorletters']); $module->assignGlobal('TUSSENVOEGSEL', $row2['tussenvoegsel']); $module->assignGlobal('ACHTERNAAM', $row2['achternaam']); $module->assignGlobal('STRAAT', $row2['straat']); $module->assignGlobal('NUMMER', $row2['nummer']); $module->assignGlobal('POSTCODE', $row2['postcode']); $module->assignGlobal('PLAATS', $row2['plaats']); $module->assignGlobal('LAND', $row2['land']); $module->assignGlobal('TELEFOON', $row2['telefoon']); $module->assignGlobal('KLANTNR', $row['account_id']); } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } /** * Gecontroleerd, betaald, verzonden, print etiket */ if($sub == 'status_all') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { $sql = 'SELECT betaalstatus, verzendstatus FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql); if(mysql_result($result, 0, 'betaalstatus') == 0 && mysql_result($result, 0, 'verzendstatus') == 0) { $sql = 'UPDATE %s SET betaalstatus = "1", betaalstatusTimestamp = %d, verzendstatus = "1", verzendstatusTimestamp = %d, archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), time()+1, time()+2, $_GET['id']); } elseif(mysql_result($result, 0, 'betaalstatus') == 0) { $sql = 'UPDATE %s SET betaalstatus = "1", betaalstatusTimestamp = %d, archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), time()+1, $_GET['id']); } elseif(mysql_result($result, 0, 'verzendstatus') == 0) { $sql = 'UPDATE %s SET verzendstatus = "1", verzendstatusTimestamp = %d, archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), time()+1, $_GET['id']); } sql_query($sql); redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d&popEt=true', BASE_DIR, $_GET['module'], $_GET['id'])); } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } /** * Gecontroleerd en akkoord */ if($sub == 'gecontroleerd_akkoord') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { /** * Check! */ $sql = 'SELECT betaalstatus FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql); if(mysql_result($result, 0, 'betaalstatus') == 0) { $sql = 'UPDATE %s SET betaalstatus = "1", betaalstatusTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $_GET['id']); } else { $sql = 'UPDATE %s SET betaalstatus = "0", betaalstatusTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); } sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } /** * Bestelling verzonden */ if($sub == 'bestelling_verzonden') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { /** * Check! */ $sql = 'SELECT verzendstatus FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql); if(mysql_result($result, 0, 'verzendstatus') == 0) { $sql = 'UPDATE %s SET verzendstatus = "1", verzendstatusTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $_GET['id']); } else { $sql = 'UPDATE %s SET verzendstatus = "0", verzendstatusTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); } sql_query($sql) or die(mysql_error()); } redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } /** * Naar archief */ if($sub == 'naar_archief') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { $sql = 'SELECT archief FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql) or print mysql_error(); if(mysql_result($result, 0, 'archief') == 0) { $sql = 'UPDATE %s SET archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $_GET['id']); } else { $sql = 'UPDATE %s SET archief = "0", archiefTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); } sql_query($sql); redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } } /** * Verstuur "Enquetes" e-mail berichten */ if($sub == 'verstuur_enquete') { verstuurEnquete(); redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); } /** * Verstuur "Betalings herinnering" e-mail berichten */ if($sub == 'verstuur_betalings_herinneringen') { verstuurHerinnering(); redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); } /** * Verstuur "Order vandaag verzonden" e-mail berichten */ if($sub == 'email_vandaag_verzonden') { verstuurOrderVerstuurd(); redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); } /** * Check barcode en redirect naar order */ if($sub == 'barcode') { $sql = 'SELECT id FROM %s WHERE ordernr = "%s"'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_POST['code']); $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) == 0) redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); else redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], mysql_result($result, 0, 'id'))); } if($sub == 'order_acties') { if($_POST['actie'] == 1) { foreach($_POST['order'] as $key => $value) { $sql = 'SELECT archief FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); $result = sql_query($sql); if(mysql_result($result, 0, 'archief') == 0) { $sql = 'UPDATE %s SET archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $key); } sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=%d', BASE_DIR, $_GET['module'], $_POST['sub'])); } elseif($_POST['actie'] == 2) { foreach($_POST['order'] as $key => $value) { $sql = 'DELETE FROM %s WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $key); sql_query($sql); $sql = 'DELETE FROM %s WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_GEGEVENS, $key); sql_query($sql); $sql = 'DELETE FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=%d', BASE_DIR, $_GET['module'], $_POST['sub'])); } elseif($_POST['actie'] == 3) { foreach($_POST['order'] as $key => $value) { $sql = 'SELECT archief FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); $result = sql_query($sql); if(mysql_result($result, 0, 'archief') == 1) { $sql = 'UPDATE %s SET archief = "0", archiefTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); } sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=%d', BASE_DIR, $_GET['module'], $_POST['sub'])); } } /** * Assign global vars */ if(isset($module)) { $module->assignGlobal('BASE_DIR', BASE_DIR); $module->assignGlobal('MODULE', $_GET['module']); $module->assignGlobal('PAGE_TITLE', $page_title); $module->printtoscreen(); } ?>
<?php defined('IN_KERNEL') or die('Aanvraag geweigerd'); global $cms, $perpagina; $cms->assignGlobal('PATHWAY', sprintf('<a href="%s/admin/index.php?module=main">Hoofdpagina</a> > <a href="%s/admin/index.php?module=%s">Orderverwerking</a>', BASE_DIR, BASE_DIR, $_GET['module'])); switch($_GET['sub']) { case 14: // vestuur de enquetes $sub = 'verstuur_enquete'; break; case 13: // vestuur de betalingsherinneringen $sub = 'verstuur_betalings_herinneringen'; break; case 12: // order acties (verwijderen, verplaatsen) $sub = 'order_acties'; break; case 11: // Check en verwerk barcode scan $sub = 'barcode'; break; case 10: // Verstuur "Order vandaag verzonden" e-mail berichten $sub = 'email_vandaag_verzonden'; break; case 9: // Naar archief $sub = 'naar_archief'; break; case 8: // Bestelling verzonden $sub = 'bestelling_verzonden'; break; case 7: // Betaling gecontroleerd en akkoord $sub = 'gecontroleerd_akkoord'; break; case 6: // Betaald, gecontroleerd, verzonden, print etiket $sub = 'status_all'; break; case 5: // Klant gegevens wijzigen $sub = 'wijzig_gegevens'; $filename = 'wijzig_gegevens.tpl'; break; case 4: // show order $sub = 'order'; $filename = 'order.tpl'; break; case 3: // zoeken $sub = 'zoeken'; $filename = 'zoeken.tpl'; break; case 2: // archief $sub = 'archief'; $filename = 'order_archief.tpl'; break; case 1: default: $sub = 'index'; $filename = 'index.tpl'; /** * Verplaats order ouder dan 2 weken naar het archief */ verlopenNaarArchief(); break; } if(isset($filename) && $filename != '') { $module = new TemplatePower(sprintf('modules/%s/templates/%s', $_GET['module'], $filename)); $module->prepare(); } /** * Overzicht van alle openstaande orders */ if($sub == 'index') { $page_title = 'Overzicht orders'; /** * Vandaag verzonden */ $vandaagTimestamp1 = mktime( 0, 0, 0, date( 'n, j, Y' ) ); $vandaagTimestamp2 = mktime( 23, 59, 59, date( 'n, j, Y' ) ); $sql = sprintf( 'SELECT * FROM %s WHERE verzendstatus = "1" AND verzendEmailVerzonden = "0" AND verzendstatusTimestamp >= %d AND verzendstatusTimestamp <= %d', TABLE_BESTELLINGEN, $vandaagTimestamp1, $vandaagTimestamp2 ); $result = sql_query($sql); $orderBetaaldVandaag = mysql_num_rows( $result ); $module->assignGlobal( 'VANDAAG_VERSTUURD', $orderBetaaldVandaag ); /** * Betalingsherinneringen */ $eenWeek = 604800; $tweeWeken = 1209600; $eenWeekGeleden = time() - $eenWeek; $tweeWekenGeleden = time() - $tweeWeken; $woensdag_5_maart = mktime(13, 0, 0, 3, 5, 2008); // timestamp: 5 maart 2008 13.00 uur $sql = 'SELECT be.*, be.id AS bestelling_id, account.*, naw.* FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id INNER JOIN %s AS naw ON be.account_id = naw.account_id WHERE be.archief = "0" AND be.betaalstatus = "0" AND be.verzendstatus = "0" AND be.herinneringVerstuurd = "0" AND be.timestamp < %d AND be.timestamp > %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, TABLE_NAW, $eenWeekGeleden, $tweeWekenGeleden); $result = sql_query($sql); $betalings_herinneringen = mysql_num_rows( $result ); $module->assignGlobal( 'BETALINGS_HERINNERINGEN', $betalings_herinneringen); /** * Enquetes */ $enquetePeriodeMin = 2592000; // = 30 dagen $enquetePeriodeMax = 3196800; // = 37 dagen $periode1 = time() - $enquetePeriodeMin; $periode2 = time() - $enquetePeriodeMax; $sql = 'SELECT be.id AS bestelling_id, be.verzendstatusTimestamp, be.ordernr, be.bestel_land, be.bankId, account.id AS account_id, account.email, naw.aanhef, naw.tussenvoegsel, naw.achternaam FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id INNER JOIN %s AS naw ON be.account_id = naw.account_id WHERE betaalstatus = "1" AND verzendstatus = "1" AND enqueteVerstuurd = "0" AND verzendstatusTimestamp < %d AND verzendstatusTimestamp > %d ORDER BY verzendstatusTimestamp ASC'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, TABLE_NAW, $periode1, $periode2); $result = sql_query($sql); $enquetes = mysql_num_rows($result); $module->assignGlobal( 'ENQUETES', $enquetes); /** * Overzicht ophalen */ if($_GET['page'] > 0) $start = $_GET['page'] * 20; else $start = 0; $sql = 'SELECT be.*, ba.naam AS banknaam FROM %s AS be INNER JOIN %s AS ba ON be.bankId = ba.id WHERE be.archief = "0" ORDER BY be.datumtijd DESC LIMIT %d, %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_BANKEN, $start, $perpagina); $result = sql_query($sql) or die(mysql_error()); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW !!! $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('ORDER_ROW'); $module->assign('ORDER_ROW.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('ORDER_ROW.ID', $row['id']); $module->assign('ORDER_ROW.ORDERNR', $row['ordernr']); $module->assign('ORDER_ROW.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('ORDER_ROW.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('ORDER_ROW.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('ORDER_ROW.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('ORDER_ROW.KLANTNR', $row['account_id']); $module->assign('ORDER_ROW.EMAIL', $row4['email']); $module->assign('ORDER_ROW.PLAATS', $row3['plaats']); $module->assign('ORDER_ROW.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('ORDER_ROW.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } /** * Build navigation * getNav() * int archief (0/1, 0 = archief) * string module () * int sub (module sub) */ $module->assignGlobal('NAV', getNav(0, $_GET['module'], 1)); } /** * Order archief */ if($sub == 'archief') { $page_title = 'Order archief'; if($_GET['page'] > 0) $start = $_GET['page'] * 20; else $start = 0; $sql = 'SELECT be.*, ba.naam AS banknaam FROM %s AS be INNER JOIN %s AS ba ON be.bankId = ba.id WHERE be.archief = "1" ORDER BY be.datumtijd DESC LIMIT %d, %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_BANKEN, $start, $perpagina); $result = sql_query($sql) or die(mysql_error()); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW !!! $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('ORDER_ROW'); $module->assign('ORDER_ROW.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('ORDER_ROW.ID', $row['id']); $module->assign('ORDER_ROW.ORDERNR', $row['ordernr']); $module->assign('ORDER_ROW.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('ORDER_ROW.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('ORDER_ROW.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('ORDER_ROW.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('ORDER_ROW.KLANTNR', $row['account_id']); $module->assign('ORDER_ROW.EMAIL', $row4['email']); $module->assign('ORDER_ROW.PLAATS', $row3['plaats']); $module->assign('ORDER_ROW.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('ORDER_ROW.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } /** * Build navigation * getNav() * int archief (0/1, 0 = archief) * string module () * int sub (module sub) */ $module->assignGlobal('NAV', getNav(1, $_GET['module'], 2)); } /** * Zoeken */ if($sub == 'zoeken') { /** * Omdat er is het oude systeem NAW gegevens aan een acount waren gekoppeld * en in het nieuwe systeem de NAW gegeven gekoppels zijn aan de bestelling * is alles per zoekfuntie geprogrammeerd. * * Bij een mindere deadline kunnen we dit eens herzien. * */ $module->assign('START_PERIODE',date("d-m-Y",time()-86400)); $module->assign('END_PERIODE',date("d-m-Y",time())); if($_SERVER['REQUEST_METHOD'] == 'POST') { $page_title = 'Zoeken - resultaten'; $module->assignGlobal('QUERY', $_POST['query']); if(strlen($_POST['search_string']) == 0 && strlen($_POST['start_periode']) == 0 && strlen($_POST['eind_periode']) == 0) { $module->newblock('NO_QUERY'); } else { $module->assign('SEARCH_STRING', $_POST['search_string']); /** * SEARCH: Ordernummer */ if($_POST['search_category'] == 'ordernummer') { $module->assign('SEARCH_ORDERNUMMER', "selected='selected'"); $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.ordernr LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_ORDERNUMBER'); } } /** * SEARCH: klantnummer */ if($_POST['search_category'] == 'klantnummer') { $module->assign('SEARCH_KLANTNUMMER', "selected='selected'"); $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = '" .$_POST['search_string']. "' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_KLANTNUMBER'); } } /** * SEARCH: betaalwijze */ if($_POST['search_category'] == 'betaalwijze') { $module->assign('SEARCH_BETAALWIJZE', "selected='selected'"); $module->assign('START_PERIODE',$_POST['start_periode']); $module->assign('END_PERIODE',$_POST['end_periode']); $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BA.naam LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_BETAALWIJZE'); } } /** * SEARCH: klantnaam */ if($_POST['search_category'] == 'klantnaam') { $module->assign('SEARCH_KLANTNAAM', "selected='selected'"); $sql = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, cms_mod_members_naw MN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = MN.account_id AND MN.achternaam LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; $sql2 = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BESTELLINGEN_NAW." BN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.id = BN.bestelling_id AND BN.achternaam LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); $result2 = sql_query($sql2) or die(mysql_error()); if(sql_numrows($result) > 0 || sql_numrows($result2) > 0) { $module->newblock('WE_HAVE_RESULTS'); $ordernr_array = array(); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } $i = 0; while($row2 = sql_fetchrow($result2)) { if ( !in_array($row2['ordernr'],$ordernr_array)){ $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } else $i = $i+1; } $otherQuery = sql_numrows($result2)-$i; } else { $module->newblock('NO_RESULTS_KLANTNAAM'); } } /** * SEARCH: periode */ if($_POST['search_category'] == 'periode') { $module->assign('SEARCH_PERIODE', "selected='selected'"); $module->assign('START_PERIODE', $_POST['start_periode']); $module->assign('END_PERIODE', $_POST['eind_periode']); $module->newblock('SHOWPERIODE'); /** * Change the dates to timestamps */ $start_periode = explode('-',$_POST['start_periode']); $start_periode = mktime(0, 0, 0, $start_periode[1], $start_periode[0], $start_periode[2]); $end_periode = explode('-',$_POST['eind_periode']); $end_periode = mktime(0, 0, 0, $end_periode[1], $end_periode[0], $end_periode[2])+86400; //add one day $sql = "SELECT *, BE.id, BA.naam FROM ".TABLE_BESTELLINGEN." BE, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.timestamp < '".$end_periode."' AND BE.timestamp > '".$start_periode."' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_PERIODE'); } } /** * SEARCH: email */ if($_POST['search_category'] == 'email') { $module->assign('SEARCH_EMAIL', "selected='selected'"); $sql = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, cms_mod_members_accounts MN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = MN.id AND MN.email LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); $ordernr_array = array(); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_EMAIL'); } } /** * SEARCH: Plaats */ if($_POST['search_category'] == 'plaats') { $module->assign('SEARCH_PLAATS', "selected='selected'"); $sql = "SELECT *, BE.id, BE.account_id FROM ".TABLE_BESTELLINGEN." BE, cms_mod_members_naw MN, ".TABLE_BANKEN." BA WHERE BE.bankId = BA.id AND BE.account_id = MN.id AND MN.plaats LIKE '%" .$_POST['search_string']. "%' ORDER BY timestamp DESC"; /** * Query uitvoeren en resultaten verzenden naar template */ $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) > 0) { $module->newblock('WE_HAVE_RESULTS'); $ordernr_array = array(); while($row = sql_fetchrow($result)) { $sql2 = sprintf('SELECT * FROM %s WHERE bestelling_id = %d', TABLE_BESTELLINGEN_GEGEVENS, $row['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = mysql_fetch_assoc($result2)) $totaal += $row2['prijs'] * $row2['aantal']; //Krijg NAW $sql3 = "SELECT * FROM ".TABLE_BESTELLINGEN_NAW." BN WHERE BN.bestelling_id = '".$row['id']."'"; $result3 = sql_query($sql3); //als geen resultaten haal uit account tabel if(sql_numrows($result3) <= 0) { $sql3 = "SELECT * FROM cms_mod_members_naw MN WHERE MN.account_id = '".$row['account_id']."'"; $result3 = sql_query($sql3); } $row3 = sql_fetchrow($result3); //Krijg account gegevens $sql4 = "SELECT * FROM `cms_mod_members_accounts` WHERE id='".$row['account_id']."'"; $result4 = mysql_query($sql4); $row4 = sql_fetchrow($result4); /** * Verzendkosten */ if($totaal >= $row['verzendkostenGrens']) $verzendkosten = 0; else $verzendkosten = $row['verzendkosten']; /** * Rembours */ if($row['bankId'] == 5) $totaal += 15; $module->newblock('SEARCH_RESULTS'); $module->assign('SEARCH_RESULTS.BANK', strtoupper(substr($row['banknaam'], 0, 2))); $module->assign('SEARCH_RESULTS.ID', $row['id']); $module->assign('SEARCH_RESULTS.ORDERNR', $row['ordernr']); $module->assign('SEARCH_RESULTS.EINDBEDRAG', number_format($totaal + $verzendkosten, 2, ',', '.')); $module->assign('SEARCH_RESULTS.BETAALSTATUS_SINDS', ($row['betaalstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['betaalstatusTimestamp'])); $module->assign('SEARCH_RESULTS.BETAALSTATUS_COLOR', getStatus($row['betaalstatus'])); $module->assign('SEARCH_RESULTS.ACHTERNAAM', sprintf('%s%s', html_entity_decode($row3['achternaam']), ($row3['tussenvoegsel'] != '') ? sprintf(', %s', $row3['tussenvoegsel']) : null)); $module->assign('SEARCH_RESULTS.KLANTNR', $row['account_id']); $module->assign('SEARCH_RESULTS.EMAIL', $row4['email']); $module->assign('SEARCH_RESULTS.PLAATS', $row3['plaats']); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_SINDS', ($row['verzendstatus'] == 0) ? date('d-m-Y H:i', $row['timestamp']) : date('d-m-Y H:i', $row['verzendstatusTimestamp'])); $module->assign('SEARCH_RESULTS.VERZENDSTATUS_COLOR', getStatus($row['verzendstatus'])); } } else { $module->newblock('NO_RESULTS_PLAATS'); } } } $page_title .= sprintf(' (%s)', ($result) ? sql_numrows($result)+$otherQuery : 0); } else { $page_title = 'Zoeken'; } } /** * Show order */ if($sub == 'order') { $page_title = ''; if($_GET['id'] > 0) { $sql = 'SELECT be.*, be.id AS orderid, be.account_id AS klantid, naw.*, bank.naam AS banknaam, account.email FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id INNER JOIN %s AS naw ON be.account_id = naw.account_id INNER JOIN %s AS bank ON be.bankId = bank.id WHERE be.id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, TABLE_NAW, TABLE_BANKEN, $_GET['id']); $result = sql_query($sql); if(sql_numrows($result) > 0) { $row = sql_fetchrow($result); /** * Disable links if needed */ if($row['betaalstatus'] == 1 && $row['verzendstatus'] == 1) { $module->assignGlobal('CHECKALL_DISABLED', ' disabled="disabled"'); $module->assignGlobal('LINK_ONCLICK', 'return false;'); $module->assignGlobal('BOX_CHECKED', ' checked="checked"'); } if($row['betaalstatus'] == 1) { $module->assignGlobal('BETAALD_CHECKED', ' checked="checked"'); $module->assignGlobal('BETAALD_DISABLED', ' disabled="disabled"'); } if($row['verzendstatus'] == 1) { $module->assignGlobal('VERZONDEN_CHECKED', ' checked="checked"'); $module->assignGlobal('VERZONDEN_DISABLED', ' disabled="disabled"'); } if($row['archief'] == 1) $module->assignGlobal('ARCHIEF_CHECKED', ' checked="checked"'); /** * Haal NAW gegevens op indien opgeslagen bij order, * anders account gekoppelde NAW gegevens ophalen (alleen voor orders van voor het nieuwe platform) */ $sql2 = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql2 = sprintf($sql2, TABLE_BESTELLINGEN_NAW, $row['orderid']); $result2 = sql_query($sql2); $nawFound = false; if(sql_numrows($result2) > 0) { /** * NAW gegevens (gekoppeld aan order) gevonden */ $nawFound = true; $row2 = sql_fetchrow($result2); $naam = sprintf('%s%s %s %s %s', ucfirst($row2['aanhef']), ($row2['aanhef']=='') ? null : '.', $row2['voorletters'], $row2['tussenvoegsel'], $row2['achternaam']); $adres = sprintf( '%s %s', $row2['straat'], $row2['nummer']); } else { /** * Oude order (geen NAW gegevens gekoppeld aan order gevonden) * Toon account gekoppelde NAW gegevens */ $naam = sprintf('%s%s %s %s %s', ucfirst($row['aanhef']), ($row['aanhef']=='') ? null : '.', $row['voorletters'], $row['tussenvoegsel'], $row['achternaam']); $adres = sprintf( '%s %s', $row['straat'], $row['nummer']); } $module->assignGlobal('RANDOM', rand(100000, 999999)); $module->assignGlobal('ORDERNR', $row['ordernr']); $module->assignGlobal('ORDERID', $row['orderid']); $module->assignGlobal('KLANTID', $row['klantid']); $module->assignGlobal('NAAM', $naam); $module->assignGlobal('ADRES', $adres); $module->assignGlobal('POSTCODE', ($nawFound) ? $row2['postcode'] : $row['postcode']); $module->assignGlobal('PLAATS', ($nawFound) ? $row2['plaats'] : $row['plaats']); $module->assignGlobal('LAND', ($nawFound) ? $row2['land'] : $row['land']); $module->assignGlobal('TELEFOON', ($nawFound) ? $row2['telefoon'] : $row['telefoon']); $module->assignGlobal('EMAIL', $row['email']); $module->assignGlobal('DATUMTIJD', date('d-m-Y H:i', $row['timestamp'])); $module->assignGlobal('BANK', $row['banknaam']); /** * Order action history */ if($row['timestamp'] != '') $history[$row['timestamp']] = 'order'; if($row['archief'] == 1) $history[$row['archiefTimestamp']] = 'archief'; if($row['betaalstatus'] == 1) $history[$row['betaalstatusTimestamp']] = 'bestellingBetaald'; if($row['verzendstatus'] == 1) $history[$row['verzendstatusTimestamp']] = 'bestellingVerzonden'; if($row['verzendEmailVerzonden'] == 1) $history[$row['verzendEmailVerzondenTimestamp']] = 'emailVerzonden'; if($row['herinneringVerstuurd'] == 1) $history[$row['herinneringVerstuurdTimestamp']] = 'herinneringVerzonden'; if($row['enqueteVerstuurd'] == 1) $history[$row['enqueteVerstuurdTimestamp']] = 'enqueteVerzonden'; //buildHistory($module, $history); /** * Build log */ krsort( $history ); foreach( $history as $key => $value ) { $module->newblock('ACTIELOG'); switch( $value ) { case 'order': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Order geplaatst; Factuur verstuurd per e-mail', $datumtijd ); $module->assign('ACTIELOG', $logValue); break; case 'bestellingBetaald': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Betaling gecontroleerd en akkoord', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'bestellingVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Bestelling verzonden naar klant', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'emailVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Klant per e-mail geinformeerd (verzonden)', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'herinneringVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Herinnering order per e-mail verstuurd', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'archief': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Verplaatst naar archief', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; case 'enqueteVerzonden': $datumtijd = date( 'd-m-Y H:i', $key ); $logValue = sprintf( '[ %s ] Vragenformulier verzonden', $datumtijd ); $module->assign( 'ACTIELOG', $logValue ); break; } } /** * Inhoud van de bestelling */ $sql2 = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql2 = sprintf($sql2, TABLE_BESTELLINGEN_GEGEVENS, $_GET['id']); $result2 = sql_query($sql2); $totaal = 0; while($row2 = sql_fetchrow($result2)) { $module->newblock('ARTIKEL_ROW'); $module->assign('ARTIKEL_ROW.NAAM', $row2['naam']); $module->assign('ARTIKEL_ROW.AANTAL', $row2['aantal']); $module->assign('ARTIKEL_ROW.PRIJS', number_format($row2['prijs'], 2, ',', '.')); $module->assign('ARTIKEL_ROW.TOTAAL', number_format($row2['prijs'] * $row2['aantal'], 2, ',', '.' )); $totaal += $row2['prijs'] * $row2['aantal']; } $module->assignGlobal('TOTAAL', number_format($totaal, 2, ',', '.')); /** * Verzendkosten */ $verzendkostenGrens = $row['verzendkostenGrens']; $verzendkosten = $row['verzendkosten']; if( $totaal >= $verzendkostenGrens ) $verzendkosten = 0; else $verzendkosten = $verzendkosten; /** * Rembours? */ if($row['bankId'] == 5) { $module->newblock('REMBOURS'); $module->assignGlobal('REMBOURS', '15,00'); $totaal += 15; } $totaal += $verzendkosten; $module->assignGlobal( 'BTW', number_format( $totaal - ( ( $totaal / 106 ) * 100 ), 2, ',', '.' ) ); $module->assignGlobal( 'VERZENDKOSTEN', number_format( $verzendkosten, 2, ',', '.' ) ); $module->assignGlobal( 'TOTAALBTW', number_format( $totaal, 2, ',', '.' ) ); /** * Etiket popup */ if(isset($_GET['popEt']) && $_GET['popEt'] == 'true') { $module->newblock('ETIKET_POPUP'); } } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } /** * Wijzig gegevens */ if($sub == 'wijzig_gegevens') { if($_GET['id'] > 0) { /** * Opslaan gegevens */ if($_SERVER['REQUEST_METHOD'] == 'POST') { /** * Haal adres gegevens op * Check of er NAW gegevens zijn gekoppeld aan de order, * anders de account NAW gegevens tonen */ $sql = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $_GET['id']); $result = sql_query($sql); if(sql_numrows($result) > 0) { /** * NAW gegevens (gekoppeld aan order) gevonden */ /** * Update de gegevens */ $sql = 'UPDATE %s SET '; foreach($_POST as $key => $value) $sql .= sprintf('%s = "%s", ', $key, htmlentities($value)); $sql = substr($sql, 0, -2); $sql .= ' WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $_GET['id']); sql_query($sql); } else { /** * Oude order (geen NAW gegevens gekoppeld aan order gevonden) * Insert gegevens bij order */ $sql = 'INSERT INTO %s SET bestelling_id = %d, '; foreach($_POST as $key => $value) $sql .= sprintf('%s = "%s", ', $key, $value); $sql = substr($sql, 0, -2); $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $_GET['id']); sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } $page_title = 'Klant gegevens wijzigen'; $sql = 'SELECT be.id AS bestelling_id, be.ordernr, account.id AS account_id, account.email FROM %s AS be INNER JOIN %s AS account ON be.account_id = account.id WHERE be.id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, TABLE_ACCOUNTS, $_GET['id']); $result = sql_query($sql); if(sql_numrows($result) == 0) redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); $row = sql_fetchrow($result); $module->assignGlobal('ORDERID', $row['bestelling_id']); $module->assignGlobal('ORDERNR', $row['ordernr']); $module->assignGlobal('EMAIL', $row['email']); /** * Haal adres gegevens op * Check of er NAW gegevens zijn gekoppeld aan de order, * anders de account NAW gegevens tonen */ $sql2 = 'SELECT * FROM %s WHERE bestelling_id = %d'; $sql2 = sprintf($sql2, TABLE_BESTELLINGEN_NAW, $row['bestelling_id']); $result2 = sql_query($sql2); if(sql_numrows($result2) > 0) { /** * NAW gegevens (gekoppeld aan order) gevonden */ $row2 = sql_fetchrow($result2); } else { /** * Oude order (geen NAW gegevens gekoppeld aan order gevonden) * Toon account gekoppelde NAW gegevens */ $sql3 = 'SELECT * FROM %s WHERE account_id = %d'; $sql3 = sprintf($sql3, TABLE_NAW, $row['account_id']); $result3 = sql_query($sql3); $row2 = sql_fetchrow($result3); $module->newblock('OLD_ORDER'); } if($row2['aanhef'] == 'dhr') $module->assignGlobal('SEL_AANHEF1', ' selected="selected"'); elseif($row2['aanhef'] == 'mevr') $module->assignGlobal('SEL_AANHEF2', ' selected="selected"'); else $module->assignGlobal('SEL_AANHEF3', ' selected="selected"'); $module->assignGlobal('VOORLETTERS', $row2['voorletters']); $module->assignGlobal('TUSSENVOEGSEL', $row2['tussenvoegsel']); $module->assignGlobal('ACHTERNAAM', $row2['achternaam']); $module->assignGlobal('STRAAT', $row2['straat']); $module->assignGlobal('NUMMER', $row2['nummer']); $module->assignGlobal('POSTCODE', $row2['postcode']); $module->assignGlobal('PLAATS', $row2['plaats']); $module->assignGlobal('LAND', $row2['land']); $module->assignGlobal('TELEFOON', $row2['telefoon']); $module->assignGlobal('KLANTNR', $row['account_id']); } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } /** * Gecontroleerd, betaald, verzonden, print etiket */ if($sub == 'status_all') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { $sql = 'SELECT betaalstatus, verzendstatus FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql); if(mysql_result($result, 0, 'betaalstatus') == 0 && mysql_result($result, 0, 'verzendstatus') == 0) { $sql = 'UPDATE %s SET betaalstatus = "1", betaalstatusTimestamp = %d, verzendstatus = "1", verzendstatusTimestamp = %d, archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), time()+1, time()+2, $_GET['id']); } elseif(mysql_result($result, 0, 'betaalstatus') == 0) { $sql = 'UPDATE %s SET betaalstatus = "1", betaalstatusTimestamp = %d, archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), time()+1, $_GET['id']); } elseif(mysql_result($result, 0, 'verzendstatus') == 0) { $sql = 'UPDATE %s SET verzendstatus = "1", verzendstatusTimestamp = %d, archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), time()+1, $_GET['id']); } sql_query($sql); redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d&popEt=true', BASE_DIR, $_GET['module'], $_GET['id'])); } else redirect(sprintf('%s/admin/index.php?module=%s', BASE_DIR, $_GET['module'])); } /** * Gecontroleerd en akkoord */ if($sub == 'gecontroleerd_akkoord') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { /** * Check! */ $sql = 'SELECT betaalstatus FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql); if(mysql_result($result, 0, 'betaalstatus') == 0) { $sql = 'UPDATE %s SET betaalstatus = "1", betaalstatusTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $_GET['id']); } else { $sql = 'UPDATE %s SET betaalstatus = "0", betaalstatusTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); } sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } /** * Bestelling verzonden */ if($sub == 'bestelling_verzonden') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { /** * Check! */ $sql = 'SELECT verzendstatus FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql); if(mysql_result($result, 0, 'verzendstatus') == 0) { $sql = 'UPDATE %s SET verzendstatus = "1", verzendstatusTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $_GET['id']); } else { $sql = 'UPDATE %s SET verzendstatus = "0", verzendstatusTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); } sql_query($sql) or die(mysql_error()); } redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } /** * Naar archief */ if($sub == 'naar_archief') { if($_GET['id'] > 0 && $_GET['do'] == 'true') { $sql = 'SELECT archief FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); $result = sql_query($sql) or print mysql_error(); if(mysql_result($result, 0, 'archief') == 0) { $sql = 'UPDATE %s SET archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $_GET['id']); } else { $sql = 'UPDATE %s SET archief = "0", archiefTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_GET['id']); } sql_query($sql); redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], $_GET['id'])); } } /** * Verstuur "Enquetes" e-mail berichten */ if($sub == 'verstuur_enquete') { verstuurEnquete(); redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); } /** * Verstuur "Betalings herinnering" e-mail berichten */ if($sub == 'verstuur_betalings_herinneringen') { verstuurHerinnering(); redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); } /** * Verstuur "Order vandaag verzonden" e-mail berichten */ if($sub == 'email_vandaag_verzonden') { verstuurOrderVerstuurd(); redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); } /** * Check barcode en redirect naar order */ if($sub == 'barcode') { $sql = 'SELECT id FROM %s WHERE ordernr = "%s"'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $_POST['code']); $result = sql_query($sql) or die(mysql_error()); if(sql_numrows($result) == 0) redirect(sprintf('%s/admin/index.php?module=%s&sub=1', BASE_DIR, $_GET['module'])); else redirect(sprintf('%s/admin/index.php?module=%s&sub=4&id=%d', BASE_DIR, $_GET['module'], mysql_result($result, 0, 'id'))); } if($sub == 'order_acties') { if($_POST['actie'] == 1) { foreach($_POST['order'] as $key => $value) { $sql = 'SELECT archief FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); $result = sql_query($sql); if(mysql_result($result, 0, 'archief') == 0) { $sql = 'UPDATE %s SET archief = "1", archiefTimestamp = %d WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, time(), $key); } sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=%d', BASE_DIR, $_GET['module'], $_POST['sub'])); } elseif($_POST['actie'] == 2) { foreach($_POST['order'] as $key => $value) { $sql = 'DELETE FROM %s WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_NAW, $key); sql_query($sql); $sql = 'DELETE FROM %s WHERE bestelling_id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN_GEGEVENS, $key); sql_query($sql); $sql = 'DELETE FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=%d', BASE_DIR, $_GET['module'], $_POST['sub'])); } elseif($_POST['actie'] == 3) { foreach($_POST['order'] as $key => $value) { $sql = 'SELECT archief FROM %s WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); $result = sql_query($sql); if(mysql_result($result, 0, 'archief') == 1) { $sql = 'UPDATE %s SET archief = "0", archiefTimestamp = NULL WHERE id = %d'; $sql = sprintf($sql, TABLE_BESTELLINGEN, $key); } sql_query($sql); } redirect(sprintf('%s/admin/index.php?module=%s&sub=%d', BASE_DIR, $_GET['module'], $_POST['sub'])); } } /** * Assign global vars */ if(isset($module)) { $module->assignGlobal('BASE_DIR', BASE_DIR); $module->assignGlobal('MODULE', $_GET['module']); $module->assignGlobal('PAGE_TITLE', $page_title); $module->printtoscreen(); } ?>