Настройки поиска (Страница 8 из 10)

namespace Newpage\Controller\Admin;
use \RS\Html\Table\Type as TableType,
    \RS\Html\Toolbar\Button as ToolbarButton,
    \RS\Html\Toolbar,
    \RS\Html\Tree,
    \RS\Html\Table,
    \RS\Html\Filter;


class MyCtrl extends \RS\Controller\Admin\Crud
{
        function __construct()
    {
         parent::__construct(new \Newpage\Model\MyApi());
    }
    
    function helperIndex()
    {
           
        
        $helper = parent::helperIndex();
        $q = $this->api->queryObj();
        $q = \RS\Db\Adapter::sqlExec('
        SELECT iazw_order_items.order_id, iazw_order_items.title, iazw_order_mydiscount.discount_id, iazw_order_discount.descr 
        FROM iazw_order_items 
        INNER JOIN iazw_order_mydiscount ON iazw_order_mydiscount.order_id = iazw_order_items.order_id INNER JOIN iazw_order_discount ON iazw_order_mydiscount.discount_id = iazw_order_discount.id');

            
        $helper = parent::helperIndex();
        $helper->setTopTitle(t('Товары со скидками'));
        $edit_pattern = $this->router->getAdminPattern('edit', array(':id' => '@id'));
        $helper->setTable(new Table\Element(array(
            'Columns' => array(         
                new TableType\String('order_id', '1'),
                new TableType\String('title', t('2')), 
                new TableType\String('discount_id', t('3')),
                new TableType\String('descr', t('14')),             
        ))));

        return $helper;
    }
    
}

<?php
/**
* ReadyScript ([url]http://readyscript.ru[/url])
*
* @copyright Copyright (c) ReadyScript lab. ([url]http://readyscript.ru[/url])
* @license [url]http://readyscript.ru/licenseAgreement/[/url]
*/
namespace Newpage\Model;

class MyApi extends \RS\Module\AbstractModel\EntityList
{
    
    function __construct()
    {
        parent::__construct(new \Shop\Model\Orm\OrderItem, //С какой таблицей через ORM объект работать
        array(
            'multisite' => false, //Объект является не мультисайтовым (без поля site_id)
            //'defaultOrder' => 'id DESC' //Сортировка по умолчанию при выборке
        ));

        parent::__construct(new \Shop\Model\Orm\Discount,
        array(
            'multisite' => true
        ));
        parent::__construct(new \Newpage\Model\Orm\Mydiscount,
        array(
           'multisite' => false
        ));

    }

}

        parent::__construct(new \Newpage\Model\Orm\Mydiscount,
        array(
            'multisite' => false
        ));

<?php

namespace Newpage\Model\Orm;
use \RS\Orm\Type;


class Mydiscount extends \RS\Orm\OrmObject
{
    protected static
        $table = 'order_mydiscount';

    function _init()
    {
        parent::_init()->append(array(           
            'order_id' => new Type\Integer(array(
                'index' => true,
                'description' => t('id заказа'),
            )),
            'discount_id' => new Type\Integer(array(
                'description' => t('id скидки'),
            )),
        ));    
    } 

    function beforeWrite($flag)
    {
        $order = new \Newpage\Model\Orm\Mydiscount();
        $order['order_id'] = $order_num;
        $res = $order->insert();
    }  
}