* * @copyright Copyright (C) 2006 - 2014 Critter BVBA All rights reserved. * @license GNU General Public License version 3 or later; see license.txt * * showitem.offer.php * * showitem.offer dialog * */ // enable or disable logging error_reporting(E_ALL); ini_set('display_errors', '1'); // 0 - disabled; 1 - enabled // $o = new offer($data->data->id); $o->details(); $sql = "SELECT `id`,`name` FROM `##_" . $_SESSION['space'] . "_entity` WHERE `deleted`=0 AND `id`>0 ORDER BY `name`;"; $DBO->query($sql); $cust = $DBO->result("objectlist"); if ($o->get("entity_id") == null) { $o->set("entity_id", $cust[0]->id); } $sql = "SELECT `id`,`name` FROM `##_" . $_SESSION['space'] . "_vat` WHERE `deleted`=0 AND `id`>0 ORDER BY `name`;"; $DBO->query($sql); $vat = $DBO->result("objectlist"); $sql = "SELECT `id`,`name` FROM `##_" . $_SESSION['space'] . "_currency` WHERE `deleted`=0 AND `id`>0 ORDER BY `name`;"; $DBO->query($sql); $curr = $DBO->result("objectlist"); $sql = "SELECT `a`.`id`,CONCAT(`a`.`name`,' - ',`a`.`sku`,' - ',`b`.`sign`,' ',`a`.`indicative_price`) `name` \n FROM `##_" . $_SESSION['space'] . "_inventory_item` `a` \n LEFT JOIN `##_" . $_SESSION['space'] . "_currency` `b` ON (`a`.`indicative_currency_id` = `b`.`id`)\n WHERE `a`.`deleted`=0 AND `a`.`id`>0 ORDER BY `name`;"; $DBO->query($sql); $items = $DBO->result("objectlist");
$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(); $deadline = $OFFER->get("payment"); } else { $offer_id = $o->get('offer_id'); $deadline = $o->get('deadline'); } $sql = "SELECT `a`.`id`,CONCAT(`a`.`sku`,' - ',`a`.`name`,' - ',`a`.`price`) `name`\n FROM `##_" . $_SESSION['space'] . "_offer_item` `a` \n WHERE `offer_id`='" . $offer_id . "'\n AND `id`>-1\n ORDER BY `name`;"; $DBO->query($sql); $items = $DBO->result("objectlist"); ?> <div class="title"><?php echo ucwords($o->get("id") == -1 ? TRANSACTION_NEW_TRANSACTION : TRANSACTION_EDIT_TRANSACTION); ?> </div> <div class="form"> <div class="column">