Файл PaymentsCore.php
<?php
/*
CREATE TABLE `ps_payment` (
`id_payment` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_product` INT( 10 ) UNSIGNED NULL ,
`summ` DECIMAL( 20, 2 ) NOT NULL DEFAULT '0',
`wmr` VARCHAR( 13 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`status` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
`firstname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`lastname` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`id_seller` INT( 10 ) UNSIGNED NOT NULL ,
`date_add` DATETIME NOT NULL ,
`date_upd` DATETIME NOT NULL ,
PRIMARY KEY ( `id_payment` )
) ENGINE = MYISAM ;
*/
class PaymentsCore extends ObjectModel
{
public $id_product;
public $id_order;
public $id_seller;
public $lastname;
public $firstname;
public $summ;
public $wmr;
public $description;
/*
* 0 - продажа (Продажа)
* 1 - запрос вывода (Запрос вывода)
* 2 - выплата (Выплата)
* 3 - РїРѕРєСѓРїРєР° СЃ внутреннего счета (Покупка с внутреннего счета)
* 4 - пополнение счета (Пополнение счета)
*/
public $status=0;
public $date_add;
public $date_upd;
protected $fieldsRequired = array('id_seller', 'summ');
protected $fieldsSize = array('description' => 255);
protected $fieldsValidate = array('id_product' => 'isUnsignedId','id_order' => 'isUnsignedId','id_seller' => 'isUnsignedId','summ' => 'isFloat','description' => 'isGenericName');
protected $table = 'payment';
protected $identifier = 'id_payment';
public function getFields()
{
parent::validateFields();
if (isset($this->id))
$fields['id_payment'] = (int)($this->id);
$fields['id_product'] = (int)($this->id_product);
$fields['id_order'] = (int)($this->id_order);
$fields['summ'] = (float)($this->summ);
$fields['wmr'] = pSQL($this->wmr);
$fields['description'] = pSQL($this->description);
$fields['status'] = (int)($this->status);
$fields['firstname'] = pSQL($this->firstname);
$fields['lastname'] = pSQL($this->lastname);
$fields['id_seller'] = (int)($this->id_seller);
$fields['date_add'] = pSQL($this->date_add);
$fields['date_upd'] = pSQL($this->date_upd);
return $fields;
}
static public function getBallance($id_customer)
{
return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue('
SELECT SUM(summ)
FROM `'._DB_PREFIX_.'payment`
WHERE `id_seller` = '.(int)($id_customer));
}
static public function getPayments($id_customer)
{
return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT *
FROM `'._DB_PREFIX_.'payment`
WHERE `id_seller` = '.(int)($id_customer).
' ORDER BY `date_upd` DESC');
}
static public function PaymentExists($id_order,$id_product)
{
return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT *
FROM `'._DB_PREFIX_.'payment`
WHERE `id_order` = '.(int)($id_order).
' AND `id_product` = '.(int)($id_product));
}
}
?>