PATH:
home
/
sparklp6
/
public_html
/
sparklerfilters-org
/
administrator
/
components
/
com_j2store
/
models
<?php /** * @package J2Store * @copyright Copyright (c)2014-17 Ramesh Elamathi / J2Store.org * @license GNU GPL v3 or later */ // No direct access to this file defined('_JEXEC') or die; class J2StoreModelVendors extends F0FModel { protected function onProcessList(&$resultArray) { foreach($resultArray as &$res){ $res->name = $res->first_name .' ' .$res->last_name; } } public function buildQuery($overrideLimits = false) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('#__j2store_vendors.*')->from("#__j2store_vendors as #__j2store_vendors"); $query->select($db->qn('#__j2store_addresses').'.j2store_address_id') ->select($db->qn('#__j2store_addresses').'.first_name') ->select($db->qn('#__j2store_addresses').'.last_name') ->select($db->qn('#__j2store_addresses').'.address_1') ->select($db->qn('#__j2store_addresses').'.address_2') ->select($db->qn('#__j2store_addresses').'.user_id') ->select($db->qn('#__j2store_addresses').'.email') ->select($db->qn('#__j2store_addresses').'.city') ->select($db->qn('#__j2store_addresses').'.zip') ->select($db->qn('#__j2store_addresses').'.zone_id') ->select($db->qn('#__j2store_addresses').'.country_id') ->select($db->qn('#__j2store_addresses').'.phone_1') ->select($db->qn('#__j2store_addresses').'.phone_2') ->select($db->qn('#__j2store_addresses').'.fax') ->select($db->qn('#__j2store_addresses').'.type') ->select($db->qn('#__j2store_addresses').'.company') ->select($db->qn('#__j2store_addresses').'.tax_number') ->select($db->qn('#__j2store_countries').'.country_name') ->select($db->qn('#__j2store_zones').'.zone_name') ->leftJoin('#__j2store_addresses ON #__j2store_addresses.j2store_address_id = #__j2store_vendors.address_id') ->leftJoin('#__j2store_countries ON #__j2store_countries.j2store_country_id = #__j2store_addresses.country_id') ->leftJoin('#__j2store_zones ON #__j2store_zones.j2store_zone_id = #__j2store_addresses.zone_id'); $this->buildOrderbyQuery($query); return $query; } public function buildOrderbyQuery(&$query){ $state = $this->getState(); $app = JFactory::getApplication(); $filter_order_Dir = $app->input->getString('filter_order_Dir','asc'); $filter_order = $app->input->getString('filter_order','j2store_vendor_id'); //check filter if($filter_order =='j2store_vendor_id' || $filter_order =='enabled' || $filter_order =='ordering' ){ $query->order('#__j2store_vendors.'.$filter_order.' '.$filter_order_Dir); }else if($filter_order =='country_name' ){ $query->order('#__j2store_countries.'.$filter_order.' '.$filter_order_Dir); }else if($filter_order =='zone_name' ){ $query->order('#__j2store_zones.'.$filter_order.' '.$filter_order_Dir); }else if($filter_order == 'first_name'){ $query->order('#__j2store_addresses.'.$filter_order.' '.$filter_order_Dir); } } public function onBeforeSave(&$data, &$table){ $app = JFactory::getApplication(); $addressTable = F0FTable::getInstance('Address','J2storeTable'); $addressTable->load($data['address_id']); $addressTable->save($data); $data['address_id'] = $addressTable->j2store_address_id; $data['j2store_user_id'] = $addressTable->user_id; return true; } }
[-] shippings.php
[edit]
[-] coupons.php
[edit]
[-] productoptions.php
[edit]
[-] inventories.php
[edit]
[-] configurations.php
[edit]
[-] orders.php
[edit]
[+]
fields
[-] productprices.php
[edit]
[-] index.html
[edit]
[-] customers.php
[edit]
[-] apps.php
[edit]
[-] productoptionvalues.php
[edit]
[-] myprofiles.php
[edit]
[-] queues.php
[edit]
[-] emailtemplates.php
[edit]
[-] eupdates.php
[edit]
[+]
behavior
[-] reports.php
[edit]
[-] invoicetemplates.php
[edit]
[-] addresses.php
[edit]
[-] taxprofiles.php
[edit]
[-] orderhistories.php
[edit]
[-] manufacturers.php
[edit]
[-] carts.php
[edit]
[-] orderitems.php
[edit]
[-] storeprofiles.php
[edit]
[-] products.php
[edit]
[-] geozones.php
[edit]
[-] currencies.php
[edit]
[-] cartitems.php
[edit]
[-] filtergroups.php
[edit]
[-] orderdownloads.php
[edit]
[-] options.php
[edit]
[-] appstores.php
[edit]
[-] customfields.php
[edit]
[-] vouchers.php
[edit]
[-] vendors.php
[edit]
[-] shippingtroubles.php
[edit]
[-] updates.php
[edit]
[-] variants.php
[edit]
[+]
..
[-] promotions.php
[edit]
[-] cartadmins.php
[edit]
[-] producttags.php
[edit]
[-] payments.php
[edit]