prepare('SELECT * FROM ctlg_product_database WHERE id = ?'); $stmt_proddb->bindValue(1, $id); $stmt_proddb->execute(); $proddb_record = $stmt_proddb->fetch(); if (!is_array($proddb_record)){ } return $proddb_record; } // ###################### // PLU- UPDATES // ###################### function productUpdate($db, $org_code){ $counters = array(); $counters['add'] = 0; $counters['upd'] = 0; $counters['del'] = 0; $counter = 0; $plu_record = array(); $proddb_record = array(); $stmt_plu = $db->prepare('SELECT * FROM ctlg_producten WHERE org_code = ? FOR UPDATE'); $stmt_plu->bindValue(1, $org_code); $stmt_plu->execute(); $plu_record = $stmt_plu->fetch(); while (is_array($plu_record) && $counter < 10000){ // counter as loop detections // get allergens from product database $proddb_record = productDb($db, $plu_record['org_code'], $plu_record['pid']); if (is_array($proddb-record)){ $upd_array = array(); $upd_array['allergeenvrij'] = $proddb_record['allergeenvrij']; $upd_array['gl'] = $proddb_record['gl']; $upd_array['ei'] = $proddb_record['ei']; $upd_array['an'] = $proddb_record['an']; $upd_array['km'] = $proddb_record['km']; $upd_array['sl'] = $proddb_record['sl']; $upd_array['sz'] = $proddb_record['sz']; $upd_array['lp'] = $proddb_record['lp']; $upd_array['sd'] = $proddb_record['sd']; $upd_array['vs'] = $proddb_record['vs']; $upd_array['sj'] = $proddb_record['sj']; $upd_array['nt'] = $proddb_record['nt']; $upd_array['ms'] = $proddb_record['ms']; $upd_array['sf'] = $proddb_record['sf']; $upd_array['wd'] = $proddb_record['wd']; $where_array = array(); $where_array['id'] = $plu_record['id']; $db->update('ctlg_producten', $upd_array, $where_array); $counters['upd']++; } $counter++; $plu_record = $stmt_plu->fetch(); } return $counters; } $counters = array(); // connect database; $db = \Contao\System::getContainer()->get('database_connection'); // update product PLU database $counters = productUpdate($db, $org_code); $this->replaceInsertTags('{{MYVAR01::records_add!!'. $counters['add']. '}}'); $this->replaceInsertTags('{{MYVAR01::records_upd!!'. $counters['upd']. '}}'); $this->replaceInsertTags('{{MYVAR01::records_del!!'. $counters['del']. '}}'); ?> teaserOnly): ?> block('alias'); ?>
cssID ?>style): ?> style="style ?>">

headline ?>

teaser ?>

more ?>

endblock(); ?> noMarkup): ?> block('content'); ?> elements) ?> endblock(); ?>
cssID ?>style): ?> style="style ?>"> printable): ?> block('syndication'); ?>
printButton): ?> pdfButton): ?> facebookButton): ?> twitterButton): ?> gplusButton): ?>
endblock(); ?> block('content'); ?> elements) ?> endblock(); ?> backlink): ?> block('backlink'); ?>

back ?>

endblock(); ?>