/**
* grid
* create the configuration of the grid
*/
public static function grid($rowNum = 10)
{
$translator = Shineisp_Registry::getInstance()->Zend_Translate;
$config['datagrid']['columns'][] = array('label' => null, 'field' => 'i.purchase_id', 'alias' => 'purchase_id', 'type' => 'selectall');
$config['datagrid']['columns'][] = array('label' => $translator->translate('ID'), 'field' => 'i.purchase_id', 'alias' => 'purchase_id', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Invoice Number'), 'field' => 'i.number', 'alias' => 'number', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Supplier'), 'field' => 'i.company', 'alias' => 'supplier', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Date'), 'field' => 'i.creationdate', 'alias' => 'creationdate', 'sortable' => true, 'searchable' => true, 'type' => 'date');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Attachment'), 'field' => 'i.document', 'alias' => 'attachment', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Payment Method'), 'field' => 'i.method_id', 'alias' => 'method', 'sortable' => true, 'searchable' => true, 'type' => 'index', 'filterdata' => PaymentsMethods::getList());
$config['datagrid']['columns'][] = array('label' => $translator->translate('Total'), 'field' => 'i.total_net', 'alias' => 'net', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('VAT'), 'field' => 'i.total_vat', 'alias' => 'vat', 'sortable' => true, 'searchable' => true, 'type' => 'string');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Grand Total'), 'field' => 'i.total', 'alias' => 'total', 'sortable' => true, 'searchable' => true, 'type' => 'string', 'class' => 'highlight');
$config['datagrid']['columns'][] = array('label' => $translator->translate('Category'), 'field' => 'i.category_id', 'alias' => 'category', 'sortable' => true, 'type' => 'index', 'searchable' => true, 'filterdata' => PurchaseCategories::getList());
$config['datagrid']['columns'][] = array('label' => $translator->translate('Statuses'), 'field' => 's.status', 'alias' => 'status', 'sortable' => true, 'searchable' => true);
$config['datagrid']['fields'] = "purchase_id, \r\n\t\t\t\t\t\t\t\t\t\t\tDATE_FORMAT(creationdate, '" . Settings::getMySQLDateFormat('dateformat') . "') as creationdate, \r\n\t\t\t\t\t\t\t\t\t\t\tDATE_FORMAT(expiringdate, '" . Settings::getMySQLDateFormat('dateformat') . "') as expiringdate, \r\n\t\t\t\t\t\t\t\t\t\t\tnumber as number, \r\n\t\t\t\t\t\t\t\t\t\t\tcompany as supplier, \r\n\t\t\t\t\t\t\t\t\t\t\tdocument as attachment, \r\n\t\t\t\t\t\t\t\t\t\t\tpm.method as method,\r\n\t\t\t\t\t\t\t\t\t\t\tpc.category as category,\r\n\t\t\t\t\t\t\t\t\t\t\ttotal_net as net, \r\n\t\t\t\t\t\t\t\t\t\t\ttotal_vat as vat, \r\n\t\t\t\t\t\t\t\t\t\t\ttotal as total,\r\n\t\t\t\t\t\t\t\t\t\t\ts.status as status";
$config['datagrid']['dqrecordset'] = Doctrine_Query::create()->select($config['datagrid']['fields'])->from('PurchaseInvoices i')->leftJoin('i.PaymentsMethods pm')->leftJoin('i.PurchaseCategories pc')->leftJoin('i.Statuses s')->orderBy('creationdate desc');
$config['datagrid']['rownum'] = $rowNum;
$config['datagrid']['basepath'] = "/admin/purchases/";
$config['datagrid']['index'] = "purchase_id";
$config['datagrid']['rowlist'] = array('10', '50', '100', '1000');
$config['datagrid']['buttons']['edit']['label'] = $translator->translate('Edit');
$config['datagrid']['buttons']['edit']['cssicon'] = "edit";
$config['datagrid']['buttons']['edit']['action'] = "/admin/purchases/edit/id/%d";
$config['datagrid']['buttons']['delete']['label'] = $translator->translate('Delete');
$config['datagrid']['buttons']['delete']['cssicon'] = "delete";
$config['datagrid']['buttons']['delete']['action'] = "/admin/purchases/delete/id/%d";
$config['datagrid']['massactions'] = array('bulk_pdf_export' => 'Pdf List', 'bulk_csv_export' => 'Csv Export');
return $config;
}
public function init()
{
// Set the custom decorator
$this->addElementPrefixPath('Shineisp_Decorator', 'Shineisp/Decorator/', 'decorator');
$translate = Shineisp_Registry::get('Zend_Translate');
$this->addElement('text', 'creationdate', array('filters' => array('StringTrim'), 'required' => true, 'label' => $translate->_('Date'), 'title' => $translate->_('eg: 01/11/2010'), 'decorators' => array('Bootstrap'), 'class' => 'form-control date', 'dateformat' => Settings::getJsDateFormat()));
$this->addElement('text', 'expiringdate', array('filters' => array('StringTrim'), 'label' => $translate->_('Expiry Date'), 'title' => $translate->_('eg: 01/11/2011'), 'decorators' => array('Bootstrap'), 'class' => 'form-control date', 'dateformat' => Settings::getJsDateFormat()));
$this->addElement('text', 'paymentdate', array('filters' => array('StringTrim'), 'label' => $translate->_('Payment Date'), 'title' => $translate->_('eg: 01/11/2010'), 'decorators' => array('Bootstrap'), 'class' => 'form-control date', 'dateformat' => Settings::getJsDateFormat()));
$this->addElement('select', 'category_id', array('label' => $translate->_('Category'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->getElement('category_id')->setAllowEmpty(false)->setMultiOptions(PurchaseCategories::getList());
$this->addElement('select', 'method_id', array('label' => $translate->_('Payment Method'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->getElement('method_id')->setAllowEmpty(false)->setMultiOptions(PaymentsMethods::getList());
$this->addElement('text', 'number', array('filters' => array('StringTrim'), 'required' => true, 'label' => $translate->_('Number'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('text', 'company', array('filters' => array('StringTrim'), 'label' => $translate->_('Company'), 'required' => true, 'title' => $translate->_('eg: Google inc.'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('text', 'total_net', array('filters' => array('StringTrim'), 'label' => $translate->_('Total Net'), 'required' => true, 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('text', 'total_vat', array('filters' => array('StringTrim'), 'label' => $translate->_('Total VAT'), 'required' => true, 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('text', 'total', array('filters' => array('StringTrim'), 'label' => $translate->_('Total'), 'required' => true, 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('textarea', 'note', array('filters' => array('StringTrim'), 'label' => $translate->_('Note'), 'decorators' => array('Bootstrap'), 'class' => 'col-lg-12 form-control'));
// If the browser client is an Apple client hide the file upload html object
if (false == Shineisp_Commons_Utilities::isAppleClient()) {
$MBlimit = Settings::findbyParam('adminuploadlimit');
$Byteslimit = Shineisp_Commons_Utilities::MB2Bytes($MBlimit);
$filetypes = Settings::findbyParam('adminuploadfiletypes', 'Admin');
$file = $this->createElement('file', 'document', array('label' => $translate->_('Document'), 'decorators' => array('File', array('ViewScript', array('viewScript' => 'partials/file.phtml', 'placement' => false))), 'description' => $translate->_('Select the document to upload. Files allowed are (%s) - Max %s', $filetypes, Shineisp_Commons_Utilities::formatSizeUnits($Byteslimit)), 'data-classButton' => 'btn btn-primary', 'data-input' => 'false', 'class' => 'filestyle'));
$file->addValidator('Extension', false, $filetypes)->addValidator('Size', false, $Byteslimit)->addValidator('Count', false, 1);
$file->setValueDisabled(true);
$file->setRequired(false);
$this->addElement($file);
}
$this->addElement('select', 'status_id', array('label' => $translate->_('Status'), 'required' => true, 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->getElement('status_id')->setAllowEmpty(false)->setMultiOptions(Statuses::getList('orders'));
$this->addElement('hidden', 'purchase_id');
}
public function init()
{
// Set the custom decorator
$this->addElementPrefixPath('Shineisp_Decorator', 'Shineisp/Decorator/', 'decorator');
$translate = Shineisp_Registry::get('Zend_Translate');
$this->addElement('text', 'name', array('filters' => array('StringTrim'), 'required' => true, 'label' => $translate->_('Name'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('text', 'account', array('filters' => array('StringTrim'), 'label' => $translate->_('Account'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('textarea', 'description', array('filters' => array('StringTrim'), 'label' => $translate->_('Description'), 'decorators' => array('Bootstrap'), 'class' => 'col-lg-12 form-control wysiwyg'));
$this->addElement('text', 'url_test', array('label' => $translate->_('URL Test'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('text', 'url_official', array('label' => $translate->_('URL Official'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->addElement('select', 'classname', array('label' => $translate->_('Plugin'), 'description' => $translate->_('This plugin is located at /library/Shineisp/Banks/ directory. For more information, look at http://www.shineisp.com/banks-modules/'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->getElement('classname')->setAllowEmpty(false)->setMultiOptions(PaymentsMethods::getPluginList());
$this->addElement('checkbox', 'enabled', array('label' => $translate->_('Enabled'), 'decorators' => array('Bootstrap'), 'class' => 'checkbox'));
$this->addElement('checkbox', 'test_mode', array('label' => $translate->_('Test Mode'), 'decorators' => array('Bootstrap'), 'class' => 'checkbox'));
$this->addElement('select', 'method_id', array('filters' => array('StringTrim'), 'required' => true, 'id' => 'paymentmethods', 'label' => $translate->_('Payment methods'), 'decorators' => array('Bootstrap'), 'class' => 'form-control'));
$this->getElement('method_id')->setAllowEmpty(false)->setMultiOptions(PaymentsMethods::getList(true));
$this->addElement('hidden', 'bank_id');
}
