ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / sparklp6 / public_html / sparklerfilters-org / administrator / components / com_j2store / tables

<?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 J2StoreTableManufacturer extends F0FTable
{

public function __construct($table, $key, &$db)
	{
		$query = $db->getQuery(true)
		->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').'.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')
		->leftJoin('#__j2store_addresses ON #__j2store_addresses.j2store_address_id = #__j2store_manufacturers.address_id');
		$this->setQueryJoin($query);
		parent::__construct($table, $key, $db);
	}

/**
	 * The event which runs before deleting a record
	 *
	 * @param   integer  $oid  The PK value of the record to delete
	 *
	 * @return  boolean  True to allow the deletion
	 */
	protected function onBeforeDelete($oid)
	{
		$status = true;
		$status =  $this->isProductAssociated($oid);
		if($status){
			//SHOULD ALSO DELETE THE ADDRESS
			// Load the post record
			$item = clone $this;
			$item->load($oid);
			if($item->address_id){
				if(F0FTable::getAnInstance('Address','J2StoreTable')->load($item->address_id)){
					if(!F0FTable::getAnInstance('Address','J2StoreTable')->delete($item->address_id))
					{
						$status = false;
					}
				}
			}
		}
		return $status;
	}

private function isProductAssociated($oid){
		$status =true;
		$model = F0FModel::getTmpInstance('Products', 'J2StoreModel');
		$items = $model->manufacturer_id($oid)->getList();
		if(isset($items) && count($items)){
			$status =false;
		}
		return $status;
	}
}

[-] productoption.php [edit]
[-] orderitemattribute.php [edit]
[-] productpriceindex.php [edit]
[-] country.php [edit]
[-] index.html [edit]
[-] report.php [edit]
[-] productquantity.php [edit]
[-] taxprofile.php [edit]
[-] order.php [edit]
[-] vendor.php [edit]
[-] productimage.php [edit]
[-] manufacturer.php [edit]
[-] productoptionvalue.php [edit]
[-] queue.php [edit]
[-] shipping.php [edit]
[-] productvariantoptionvalue.php [edit]
[-] metafield.php [edit]
[-] customer.php [edit]
[-] orderitem.php [edit]
[-] payment.php [edit]
[-] optionvalue.php [edit]
[-] productprice.php [edit]
[-] coupon.php [edit]
[-] myprofile.php [edit]
[-] cart.php [edit]
[-] eupdate.php [edit]
[-] orderinfo.php [edit]
[-] app.php [edit]
[-] variant.php [edit]
[-] taxrate.php [edit]
[-] product.php [edit]
[-] geozone.php [edit]
[-] filter.php [edit]
[-] option.php [edit]
[-] vendoruser.php [edit]
[-] promotion.php [edit]
[-] voucher.php [edit]
[-] productfilter.php [edit]
[-] filtergroup.php [edit]
[-] productfile.php [edit]
[+] ..
[-] customfield.php [edit]