Gecko [ 167.86.127.34 ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.DS_Store	6 KB	-rwxrwxrwx
.mad-root	0 B	-rw-r--r--
CreditCard_Order.php	2.2 KB	-rwxrwxrwx
CreditCard_OrderState.php	3.39 KB	-rwxrwxrwx
EpaycoOrder.php	2.48 KB	-rwxrwxrwx
index.php	1.27 KB	-rwxrwxrwx
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : EpaycoOrder.php

<?php
/**
 * Clase en donde se guardan las transacciones
 */

class EpaycoOrder extends ObjectModel{
	public $id;
	public $id_payco;
	public $order_id;
	public $order_stock_restore;
	public $order_stock_discount;
	public $order_status;
	
	
	/**
	 * Guarda el registro de una oden
	 * @param int $orderId
	 * @param array $stock
	 */
	public static function create($orderId, $stock)
	{
		
		$db = Db::getInstance();
			$result = $db->execute('
			INSERT INTO `'._DB_PREFIX_.'payco`
			( `order_id`, `order_stock_restore` )
			VALUES
			("'.intval($orderId).'","'.$stock.'")');
		return $result;
	}

/**
	 * Consultar si existe el registro de una oden
	 * @param int $orderId
	 */	
	public static function ifExist($orderId)
	{
		$sql = 'SELECT COUNT(*) FROM '.EpaycoOrder::$definition['table'].' WHERE order_id ='.$orderId;
		
		if (\Db::getInstance()->getValue($sql) > 0)
			return true;
		return false;
	}

/**
	 * Consultar si a una orden ya se le descconto el stock
	 * @param int $orderId
	 */	
	public static function ifStockDiscount($orderId)
	{	
		$db = Db::getInstance();
		$result = $db->getRow('
			SELECT `order_stock_discount` FROM `'.EpaycoOrder::$definition['table'].'`
			WHERE `order_id` = "'.intval($orderId).'"');

return intval($result["order_stock_discount"]) != 0 ? true : false;
		
	}

/**
	 * Actualizar que ya se le descontó el stock a una orden
	 * @param int $orderId
	 */	
	public static function updateStockDiscount($orderId)
	{
		$db = Db::getInstance();
		$result = $db->update('payco', array('order_stock_discount'=>1), 'order_id = '.(int)$orderId );

return $result ? true : false;
	}
	
	/**
	 * Crear la tabla en la base de datos.
	 * @return true or false
	 */
	public static function setup()
	{
		$sql = array();
		$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'payco` (
		    `id` int(11) NOT NULL AUTO_INCREMENT,
		    `id_payco` INT(11) NULL,
		    `order_id` INT NULL,
		    `order_stock_restore` INT NULL,
		    `order_stock_discount` INT NULL,
		    `order_status` TEXT NULL,
		    PRIMARY KEY  (`id`)
		) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8;';

foreach ($sql as $query) {
		    if (Db::getInstance()->execute($query) == false) {
		        return false;
		    }
		}
	}

/**
	 * Borra la tabla en la base de datos.
	 * @return true or false
	 */
	public static function remove(){
		$sql = array(
				'DROP TABLE IF EXISTS '._DB_PREFIX_.'payco'
		);

foreach ($sql as $query) {
		    if (Db::getInstance()->execute($query) == false) {
		        return false;
		    }
		}
	}
}

${this.title}

Code Editor : EpaycoOrder.php