编辑文件 - PiSponsors.php

✏️ 正在编辑: PiSponsors.php

路径: /home/bpioifn/www/pigmentse/modules/pisponsors/models/PiSponsors.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php
# /modules/pisponsors/models/PiSponsorsModel.php

/**
 * pi sponsors - A Prestashop Module
 * 
 * pi sponsors
 * 
 * @author pi sponsors <pi.sponsors@yopmail.com>
 * @version 0.0.1
 */

if (!defined('_PS_VERSION_')) exit;

class PiSponsorsModel extends ObjectModel
{
	/** Your fields names, adapt to your needs */
	public $id;
	public $name;

/** Your table definition, adapt to your needs */
	public static $definition = [
		'table' => 'pi_sponsors',
		'primary' => 'id_pi_sponsors',
		'fields' => [
			'name' => [
				'type' => self::TYPE_STRING,
				'validate' => 'isString',
				'size' => 256,
				'required' => true,
			],
		],
	];

/** Create your table into database, adapt to your needs */
	public static function installSql()
	{
		$tableName = _DB_PREFIX_ . self::$definition['table'];
		$primaryField = self::$definition['primary'];
		$sql = array();
		
		/*if (Db::getInstance()->execute("SELECT `id_pi_sponsor` from `"._DB_PREFIX_."customer`") == false) {
			$sql[] = "ALTER TABLE `"._DB_PREFIX_."customer` ADD `id_pi_sponsor` int(10) NULL AFTER `id_customer`";
		}*/
		$sql[] = "ALTER TABLE `"._DB_PREFIX_."customer` ADD `id_pi_sponsor` int(10) NULL AFTER `id_customer`";
		$sql[] = "CREATE TABLE IF NOT EXISTS `{$tableName}` (
				`{$primaryField}` int(10) unsigned NOT NULL AUTO_INCREMENT,
				`name` varchar(256) NOT NULL,
				PRIMARY KEY (`{$primaryField}`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;
		";
		
		
		foreach ($sql as $query) {
			try {
				if (Db::getInstance()->execute($query) == false) {
					return false;
				}
			} catch (Exception $e) {
				//echo 'Exception reçue : ',  $e->getMessage(), "\n";
			}
			
		}
		return true;
	}

public static function uninstallSql()
	{
		$tableName = _DB_PREFIX_ . self::$definition['table'];
		$primaryField = self::$definition['primary'];
		$sql = array();
		/*if (Db::getInstance()->execute("SELECT `id_pi_sponsor` from `"._DB_PREFIX_."customer`") == true) {
			$sql[] = "ALTER TABLE `"._DB_PREFIX_."customer` DROP `id_pi_sponsor`;";
		}*/
		$sql[] = "ALTER TABLE `"._DB_PREFIX_."customer` DROP `id_pi_sponsor`;";
		$sql[] = "DROP TABLE IF EXISTS `{$tableName}`;";
		foreach ($sql as $query) {
			try {
				if (Db::getInstance()->execute($query) == false) {
					return false;
				}
			} catch (Exception $e) {
				//echo 'Exception reçue : ',  $e->getMessage(), "\n";
			}
			
		}
		return true;
	}

public static function getSponsors() {
		$q = new DbQuery();
		$q->select('*')
		->from(self::$definition['table'])
		;
		return Db::getInstance()->executeS($q);
	}

/**
	 * @param int $id_customer
	 * @return int|boolean
	 */
	public static function getCustomerSponsor($id_customer) {
		if($id_customer) {
			return Db::getInstance()->getValue('SELECT `id_pi_sponsor` from `'._DB_PREFIX_.'customer` where id_customer='.$id_customer);
		}
		return false;
	}

/**
	 * @param int $id_sponsor
	 * @param int $id_customer
	 * @return int|boolean
	 */
	public static function setCustomerSponsor($id_customer, $id_sponsor) {
		if($id_customer && $id_sponsor) {
			return Db::getInstance()->update('customer', [
				'id_pi_sponsor' => $id_sponsor
			], 'id_customer='.$id_customer);
		}
		return false;
	}
}

← 返回文件管理器