function load($x)
{
$db = new Database();
$sql = sprintf("select id, order_id, product_id, qty, qty_inv from order_supplies where id = %d", $x);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->id = intval($r["id"]);
$this->order_id = intval($r["order_id"]);
$this->product_id = intval($r["product_id"]);
$this->qty = intval($r["qty"]);
$this->qty_inv = intval($r["qty_inv"]);
}
}
function load($x)
{
$db = new Database();
$sql = sprintf("select id, order_id, name, value, data from order_props where id = %d", $x);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->id = intval($r["id"]);
$this->order_id = intval($r["order_id"]);
$this->name = stripslashes($r["name"]);
$this->value = stripslashes($r["value"]);
$this->data = stripslashes($r["data"]);
}
}
function load($x)
{
$db = new Database();
$sql = sprintf("select id, order_id, address_id, size_id, copy_count " .
"from delivery_counts " .
"where id = %d", $x);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->id = intval($r["id"]);
$this->order_id = intval($r["order_id"]);
$this->address_id = intval($r["address_id"]);
$this->size_id = intval($r["size_id"]);
$this->copy_count = intval($r["copy_count"]);
}
}
function load($x)
{
$db = new Database();
$sql = sprintf("select id, order_id, originals, duplicates, size_id, image, ftpurl from order_lines where id = %d", $x);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->id = intval($r["id"]);
$this->order_id = intval($r["order_id"]);
$this->originals = intval($r["originals"]);
$this->duplicates = intval($r["duplicates"]);
$this->size_id = intval($r["size_id"]);
$this->image = $r["image"];
$this->ftpurl = $r["ftpurl"];
}
}
function Store_Categories($arr = array())
{
$this->items = array();
if (is_array($arr)) {
if (count($arr) == 0) {
$db = new Database();
$sql = "select id from store_category order by descr";
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$arr[] = $r["id"];
}
$db->close();
}
foreach ($arr as $a) {
$this->items[] = new Store_Category($a);
}
} else {
$this->items[] = new Store_Category($arr);
}
}
function SiteConfigs($arr = array())
{
$this->items = array();
if (is_array($arr)) {
if (count($arr) == 0) {
$db = new Database();
$sql = "select config_keyword from siteconfig order by config_keyword";
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$arr[] = $r["config_keyword"];
}
$db->close();
}
foreach ($arr as $a) {
$this->items[] = new SiteConfig($a);
}
} else {
$this->items[] = new SiteConfig($arr);
}
}
function fetch_by_code($arr)
{
$tmp = array();
$db = new Database();
foreach ($arr as $a) {
$sql = sprintf("select id from bindings where code = '%s'", $a);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
if (intval($db->results[0]["id"]) > 0) $tmp[] = $db->results[0]["id"];
}
$db->close();
$this->items = array();
foreach ($tmp as $t) {
$this->items[] = new Binding($t);
}
}
function get_by_category($x)
{
$db = new Database();
$sql = sprintf("select id from store_subcat where category_id = %d order by descr", $x);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
$tmp = array();
foreach ($db->results as $r) {
$tmp[] = $r["id"];
}
$db->close();
$this->items = array();
foreach ($tmp as $t) {
$this->items[] = new Store_Subcat($t);
}
}
function Admins($arr = array())
{
$this->items = array();
if (is_array($arr)) {
if (count($arr) == 0) {
$db = new Database();
$sql = "select id from admin order by lname, fname";
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$arr[] = $r["id"];
}
$db->close();
}
foreach ($arr as $a) {
$this->items[] = new Admin($a);
}
} else {
$this->items[] = new Admin($arr);
}
}
function get_order_masters_by_client($client = 0)
{
$this->items = array();
$db = new Database();
if ($client == 0) {
$sql = sprintf("select distinct master_id from orders where service_id > 0 order by id desc");
} else {
$sql = sprintf("select distinct master_id from orders where service_id > 0 and customer_id = %d order by id desc", $client);
}
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->items[] = $r["master_id"];
}
$db->close();
}
function get_log_by_table($table_name, $page = 0)
{
$this->items = array();
$db = new Database();
if ($page == 0) {
$sql = sprintf("select id from audit_log where table_name = '%s' order by id desc", $table_name, $status);
} else {
$sql = sprintf("select id from audit_log where table_name = '%s' order by id desc limit %d offset %d", $table_name, PER_PAGE, ($page - 1) * PER_PAGE);
}
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->items[] = new Audit_Log($r["id"]);
}
$db->close();
}
function get_pickups_by_order($order_id, $page = 0)
{
$this->items = array();
$db = new Database();
if ($page == 0) {
$sql = sprintf("select id from schedule where order_id = %d order by pickup_date", $order_id);
} else {
$sql = sprintf("select id from schedule where order_id = %d order by pickup_date limit %d offset %d", $order_id, PER_PAGE, ($page - 1) * PER_PAGE);
}
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->items[] = new Schedule($r["id"]);
}
$db->close();
}
/* Database credentials */
// define("DB_NAME", "db18534_soho");
// define("DB_USER", "db18534");
// define("DB_PASS", "7VcxMsFX");
// define("DB_HOST", "internal-db.s18534.gridserver.com");
define("DB_NAME", "gigantic");
define("DB_USER", "gigantic_admin");
define("DB_PASS", "Dr0iu99#");
define("DB_HOST", "localhost");
require_once($_SERVER["DOCUMENT_ROOT"] . "/include/db.class.php");
$config = new Database();
$sql = "select config_keyword, config_type, config_value from siteconfig";
$config->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($config->results as $r) {
switch ($r["config_type"]) {
case "VARCHAR" :
define($r["config_keyword"], $r["config_value"]);
break;
case "BOOLEAN" :
define($r["config_keyword"], (intval($r["config_value"]) == 1 ? true : false));
break;
case "INTEGER" :
define($r["config_keyword"], intval($r["config_value"]));
break;
}
}
$config->close();
function get_delivery_counts()
{
$arr = array();
$db = new Database();
$sql = sprintf("select id from delivery_counts where order_id = %d and address_id = %d", $this->order_id, $this->id);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$arr[] = $r["id"];
}
$this->delivery_counts = new Delivery_Counts($arr);
}
public function search($searchFields)
{
$db = new Database();
$sql = "select * from company ";
foreach ($searchFields as $field => $val)
{
switch ($field)
{
default:
$where .= "and ( $field = '$val' ) \n";
break;
}
}
$where = trim($where, 'and ');
if (!empty($searchFields)) $where = 'WHERE '.$where;
$db->fetchRowObjects($sql.$where, __FILE__, __LINE__, false);
return $db->results;
}
function get_supply_orders_by_status($status = ORDER_OPEN)
{
$this->items = array();
$db = new Database();
$sql = sprintf("select id from orders where service_id < 0 and status = %d order by id desc", $status);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$this->items[] = $r["id"];
}
$db->close();
}
function Laminates($arr = array())
{
$this->items = array();
if (is_array($arr)) {
if (count($arr) == 0) {
$db = new Database();
$sql = "select id from laminates order by listing_order, code";
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
foreach ($db->results as $r) {
$arr[] = $r["id"];
}
$db->close();
}
foreach ($arr as $a) {
$this->items[] = new Laminate($a);
}
} else {
$this->items[] = new Laminate($arr);
}
}
function c_descr($id)
{
$db = new Database();
$sql = sprintf("select id, descr from store_category where id = %d", $id);
$db->fetchRowObjects($sql, __FILE__, __LINE__, false);
$results = $db->results;
$db->close();
return array("id" => $results[0]["id"], "descr" => $results[0]["descr"]);
}
