예제 #1
0
 /**
  * Constructor
  *
  * Base constructor
  *
  * @access public
  */
 public function __construct()
 {
     parent::__construct();
     $this->tableName = 'addon_products';
     $this->primaryKeyName = 'id';
     $this->searchFields = array('id', 'price', 'description');
 }
예제 #2
0
 public function __construct()
 {
     parent::__construct();
     $this->tableName = 'customer_groups';
     $this->primaryKeyName = 'customergroupid';
     $this->customKeyName = '';
     $this->searchFields = array('customergroupid', 'groupname');
 }
예제 #3
0
 public function __construct()
 {
     parent::__construct();
     $this->tableName = 'products';
     $this->primaryKeyName = 'productid';
     $this->customKeyName = '';
     $this->searchFields = array('productid', 'prodname', 'prodcode');
 }
예제 #4
0
 /**
  * Constructor
  *
  * Base constructor
  *
  * @access public
  */
 public function __construct()
 {
     parent::__construct();
     $this->customer = new ISC_ENTITY_CUSTOMER();
     $this->tableName = 'pic';
     $this->primaryKeyName = 'picid';
     $this->searchFields = array('picid', 'filename', 'description');
 }
예제 #5
0
 public function __construct()
 {
     parent::__construct();
     $this->tableName = 'shipping_addresses';
     $this->primaryKeyName = 'shipid';
     $this->customKeyName = 'shipformsessionid';
     $this->searchFields = array('shipid', 'shipcustomerid', 'shipfirstname', 'shiplastname', 'shipaddress1', 'shipzip');
 }
예제 #6
0
 /**
  * Constructor
  *
  * Base constructor
  *
  * @access public
  */
 public function __construct()
 {
     parent::__construct();
     $this->shipping = new ISC_ENTITY_SHIPPING();
     $this->tableName = 'orders';
     $this->primaryKeyName = 'orderid';
     $this->customKeyName = 'ordformsessionid';
     $this->searchFields = array('orderid', 'ordtoken', 'ordcustid', 'ordbillfirstname', 'ordbilllastname', 'ordbillemail', 'ordshipfirstname', 'ordshiplastname', 'ordshipemail');
 }
예제 #7
0
 /**
  * Constructor
  *
  * Base constructor
  *
  * @access public
  */
 public function __construct()
 {
     parent::__construct();
     $this->shipping = new ISC_ENTITY_SHIPPING();
     $this->group = new ISC_ENTITY_CUSTOMERGROUP();
     $this->tableName = 'customers';
     $this->primaryKeyName = 'customerid';
     $this->customKeyName = 'custformsessionid';
     $this->searchFields = array('customerid', 'custgroupid', 'custconfirstname', 'custconlastname', 'custconemail', 'custconphone');
 }
예제 #8
0
	/**
	 * Constructor
	 *
	 * Base constructor
	 *
	 * @access public
	 */
	public function __construct()
	{
		$schema = array(
				"customerid" => "int",
				"custpassword" => "text",
				"custconcompany" => "text",
				"custconfirstname" => "text",
				"custconlastname" => "text",
				"custconemail" => "text",
				"custconphone" => "text",
				"customertoken" => "text",
				"customerpasswordresettoken" => "text",
				"customerpasswordresetemail" => "text",
				"custdatejoined" => "date",
				"custlastmodified" => "date",
				"custimportpassword" => "text",
				"custstorecredit" => "price",
				"custregipaddress" => "text",
				"custgroupid" => "int",
				"custnotes" => "text",
				"custformsessionid" => "int",
		);

		$tableName = "customers";
		$primaryKeyName = "customerid";
		$searchFields = array(
				"customerid",
				"custgroupid",
				"custconfirstname",
				"custconlastname",
				"custconemail",
				"custconphone"
		);

		$customKeyName = "custformsessionid";

		parent::__construct($schema, $tableName, $primaryKeyName, $searchFields, $customKeyName);

		$this->shipping = new ISC_ENTITY_SHIPPING();
		$this->group = new ISC_ENTITY_CUSTOMERGROUP();
	}
예제 #9
0
	public function __construct()
	{
		$schema = array(
				"customergroupid" => "int",
				"groupname" => "text",
				"discount" => "price",
				"discountmethod" => "text",
				"isdefault" => "bool",
				"categoryaccesstype" => "text",
		);

		$tableName = "customer_groups";
		$primaryKeyName = "customergroupid";
		$searchFields = array(
				'customergroupid',
				'groupname'
		);

		$customKeyName = "";

		parent::__construct($schema, $tableName, $primaryKeyName, $searchFields, $customKeyName);
	}
예제 #10
0
	/**
	 * Constructor
	 *
	 * Base constructor
	 *
	 * @access public
	 */
	public function __construct()
	{
		$schema = array(
				"shipid" => "int",
				"shipcustomerid" => "int",
				"shipfirstname" => "text",
				"shiplastname" => "text",
				"shipcompany" => "text",
				"shipaddress1" => "text",
				"shipaddress2" => "text",
				"shipcity" => "text",
				"shipstate" => "text",
				"shipzip" => "text",
				"shipcountry" => "text",
				"shipphone" => "text",
				"shipstateid" => "int",
				"shipcountryid" => "int",
				"shipdestination" => "text",
				"shiplastused" => "int",
				"shipformsessionid" => "int",
		);

		$tableName = "shipping_addresses";
		$primaryKeyName = "shipid";
		$searchFields = array(
				"shipid",
				"shipcustomerid",
				"shipfirstname",
				"shiplastname",
				"shipaddress1",
				"shipzip"
		);

		$customKeyName = "shipformsessionid";

		parent::__construct($schema, $tableName, $primaryKeyName, $searchFields, $customKeyName);
	}
예제 #11
0
	public function __construct()
	{
		$schema = array(
			"combinationid" => "int",
			"vcproductid" => "int",
			"vcproducthash" => "text",
			"vcvariationid" => "int",
			"vcenabled" => "bool",
			"vcoptionids" => "text",
			"vcsku" => "text",
			"vcpricediff" => "text",
			"vcprice" => "price",
			"vcweightdiff" => "text",
			"vcweight" => "measurement",
			"vcimage" => "text",
			"vcimagezoom" => "text",
			"vcimagestd" => "text",
			"vcimagethumb" => "text",
			"vcstock" => "int",
			"vclowstock" => "int"
		);

		$tableName = "product_variation_combinations";
		$primaryKeyName = "combinationid";
		$searchFields = array(
				"combinationid",
				"vcproductid",
				"vcsku"
		);

		$customKeyName = "";

		parent::__construct($schema, $tableName, $primaryKeyName, $searchFields, $customKeyName);

		$this->productEntity = new ISC_ENTITY_PRODUCT();
	}
예제 #12
0
	/**
	 * Constructor
	 *
	 * Base constructor
	 *
	 * @access public
	 */
	public function __construct()
	{
		$schema = array(
				"orderid" => "int",
				"ordtoken" => "text",
				"ordcustid" => "int",
				"orddate" => "date",
				"ordlastmodified" => "date",
				"subtotal_ex_tax" => "price",
				"subtotal_inc_tax" => "price",
				"subtotal_tax" => "price",
				"total_tax" => "price",
				"shipping_cost_ex_tax" => "price",
				"shipping_cost_inc_tax" => "price",
				"shipping_cost_tax" => "price",
				'shipping_cost_tax_class_id' => 'int',
				'handling_cost_ex_tax' => 'price',
				'handling_cost_inc_tax' => 'price',
				'handling_cost_tax' => 'price',
				'handling_cost_tax_class_id' => 'int',
				'wrapping_cost_ex_tax' => 'price',
				'wrapping_cost_inc_tax' => 'price',
				'wrapping_cost_tax' => 'price',
				'wrapping_cost_tax_class_id' => 'int',
				'total_ex_tax' => 'price',
				'total_inc_tax' => 'price',
				"ordstatus" => "int",
				"ordtotalqty" => "int",
				"ordtotalshipped" => "int",
				"orderpaymentmethod" => "text",
				"orderpaymentmodule" => "text",
				"ordpayproviderid" => "text",
				"ordpaymentstatus" => "text",
				"ordrefundedamount" => "price",
				"ordbillfirstname" => "text",
				"ordbilllastname" => "text",
				"ordbillcompany" => "text",
				"ordbillstreet1" => "text",
				"ordbillstreet2" => "text",
				"ordbillsuburb" => "text",
				"ordbillstate" => "text",
				"ordbillzip" => "text",
				"ordbillcountry" => "text",
				"ordbillcountrycode" => "text",
				"ordbillcountryid" => "int",
				"ordbillstateid" => "int",
				"ordbillphone" => "text",
				"ordbillemail" => "text",
				"ordisdigital" => "bool",
				"orddateshipped" => "date",
				"ordstorecreditamount" => "price",
				"ordgiftcertificateamount" => "price",
				"ordinventoryupdated" => "bool",
				"ordonlygiftcerts" => "bool",
				"extrainfo" => "text",
				"ordipaddress" => "text",
				"ordgeoipcountry" => "text",
				"ordgeoipcountrycode" => "text",
				"ordcurrencyid" => "int",
				"orddefaultcurrencyid" => "int",
				"ordcurrencyexchangerate" => "price",
				"ordnotes" => "text",
				"ordcustmessage" => "text",
				"ordvendorid" => "int",
				"ordformsessionid" => "int",
				"orddiscountamount" => "price",
				'shipping_address_count' => 'int',
				'coupon_discount' => 'price',
				'deleted' => 'bool',
		);

		$tableName = "orders";
		$primaryKeyName = "orderid";
		$searchFields = array(
				"orderid",
				"ordtoken",
				"ordcustid",
				"ordbillfirstname",
				"ordbilllastname",
				"ordbillemail",
		);

		$customKeyName = "ordformsessionid";

		parent::__construct($schema, $tableName, $primaryKeyName, $searchFields, $customKeyName);

		$this->shipping = new ISC_ENTITY_SHIPPING();
		$this->product = new ISC_ENTITY_PRODUCT();
		$this->customer = new ISC_ENTITY_CUSTOMER();

		$this->useTransactions = true;
	}
예제 #13
0
	public function __construct()
	{
		$schema = array(
				"productid" => "int",
				"prodname" => "text",
				"prodtype" => "int",
				"prodcode" => "text",
				"prodfile" => "text",
				"proddesc" => "text",
				"prodsearchkeywords" => "text",
				"prodavailability" => "text",
				"prodprice" => "price",
				"prodcostprice" => "price",
				"prodretailprice" => "price",
				"prodsaleprice" => "price",
				"prodcalculatedprice" => "price",
				"prodsortorder" => "int",
				"prodvisible" => "bool",
				"prodfeatured" => "bool",
				"prodvendorfeatured" => "bool",
				"prodrelatedproducts" => "text",
				"prodcurrentinv" => "int",
				"prodlowinv" => "int",
				"prodoptionsrequired" => "bool",
				"prodwarranty" => "text",
				"prodweight" => "measurement",
				"prodwidth" => "measurement",
				"prodheight" => "measurement",
				"proddepth" => "measurement",
				"prodfixedshippingcost" => "price",
				"prodfreeshipping" => "bool",
				"prodinvtrack" => "int",
				"prodratingtotal" => "int",
				"prodnumratings" => "int",
				"prodnumsold" => "int",
				"proddateadded" => "date",
				"prodbrandid" => "int",
				"prodnumviews" => "int",
				"prodpagetitle" => "text",
				"prodmetakeywords" => "text",
				"prodmetadesc" => "text",
				"prodlayoutfile" => "text",
				"prodvariationid" => "int",
				"prodallowpurchases" => "bool",
				"prodhideprice" => "bool",
				"prodcallforpricinglabel" => "text",
				"prodcatids" => "text",
				"prodlastmodified" => "date",
				"prodvendorid" => "int",
				"prodhastags" => "bool",
				"prodwrapoptions" => "text",
				"prodconfigfields" => "text",
				"prodeventdaterequired" => "bool",
				"prodeventdatefieldname" => "text",
				"prodeventdatelimited" => "bool",
				"prodeventdatelimitedtype" => "int",
				"prodeventdatelimitedstartdate" => "date",
				"prodeventdatelimitedenddate" => "date",
				"prodmyobasset" => "text",
				"prodmyobincome" => "text",
				"prodmyobexpense" => "text",
				"prodpeachtreegl" => "text",
				"prodcondition" => "text",
				"prodshowcondition" => "bool",
				"product_enable_optimizer" => "bool",
				"prodpreorder" => "bool",
				"prodreleasedate" => "int",
				"prodreleasedateremove" => "bool",
				"prodpreordermessage" => "text",
				"prodminqty" => "int",
				"prodmaxqty" => "int",
				'tax_class_id' => 'int',
				"opengraph_type" => "text",
				"opengraph_use_product_name" => "bool",
				"opengraph_title" => "text",
				"opengraph_use_meta_description" => "bool",
				"opengraph_description" => "text",
				"opengraph_use_image" => "bool",
				"upc" => "text",
				"disable_google_checkout" => "int",
				"last_import" => "int",
		);

		$tableName = "products";
		$primaryKeyName = "productid";
		$searchFields = array(
				"productid",
				"prodname",
				"prodcode"
		);

		$customKeyName = "";

		parent::__construct($schema, $tableName, $primaryKeyName, $searchFields, $customKeyName);
	}