* * @copyright Copyright (C) 2006 - 2014 Critter BVBA All rights reserved. * @license GNU General Public License version 3 or later; see license.txt * * showitem.transaction.php * * showitem.transaction dialog * */ // enable or disable logging error_reporting(E_ALL); ini_set('display_errors', '1'); // 0 - disabled; 1 - enabled // $o = new transaction($data->data->id); $o->details(); $sql = "SELECT `id`,CONCAT(`name`, ' (',`uid`,')') `name` FROM `##_" . $_SESSION['space'] . "_entity` WHERE `deleted`=0 AND `id`>0 ORDER BY `name`;"; $DBO->query($sql); $cust = $DBO->result("objectlist"); if ($o->get("id") == -1) { $entity_id = $cust[0]->id; } else { $entity_id = $o->get("entity_id"); } $sql = "SELECT `id`,`reference` FROM `##_" . $_SESSION['space'] . "_offer` WHERE `deleted`=0 AND `id`>0 AND `entity_id`='" . $entity_id . "' ORDER BY `reference`;"; $DBO->query($sql); $offer = $DBO->result("objectlist"); if ($o->get("id") == -1) { $offer_id = $offer[0]->id; $OFFER = new offer($offer_id); $OFFER->details();
*/ // enable or disable logging error_reporting(E_ALL); ini_set('display_errors', '1'); // 0 - disabled; 1 - enabled // $sql = "SELECT `a`.`name`, `b`.`id`,`b`.`uid`,`b`.`reference`,DATE_FORMAT(`b`.`date`,'%Y-%m-%d') `date`, DATE_FORMAT(DATE_ADD(`b`.`date`,INTERVAL `b`.`deadline` DAY),'%Y-%m-%d') `duedate`, `b`.`id` `transaction_id`,`b`.`offer_id`\n FROM `##_" . $_SESSION['space'] . "_entity` `a`\n LEFT JOIN `##_" . $_SESSION['space'] . "_transaction` `b` ON (`a`.`id`=`b`.`entity_id`)\n WHERE `b`.`satisfied`=0 AND `b`.`id`>-1\n AND DATE_ADD(`b`.`date`,INTERVAL `b`.`deadline` DAY)<CURDATE()\n ORDER BY `a`.`name` asc, `duedate` desc;"; $DBO->query($sql); $customer = ""; $count = 0; ?> <div class="dashboard"> <?php foreach ($DBO->result("objectlist") as $row) { $TRANSACTION = new transaction($row->transaction_id); $TRANSACTION->details(); $OFFER = new offer($row->offer_id); $OFFER->details(); if ($row->name != $customer) { $customer = $row->name; if ($count != 0) { echo "</div>"; } ?> <div class="customer"><?php echo $row->name; ?> </div> <div class="itemlist"> <?php }