public function __construct($id)
{
parent::__construct($id);
$this->view = 'banci.documente_necesare.index';
$this->icon = 'admin/img/icons/dt/gali.png';
$this->caption = 'Documente';
$this->toolbar = 'banci.documente_necesare.toolbar';
$this->name = 'dt';
$this->display_start = 0;
$this->display_length = 10;
$this->default_order = "1,'asc'";
$this->form = 'Credite\\Banci\\Form\\DocumenteNecesareForm';
$this->css = 'admin/css/dt/dt.css, admin/css/dt/toolbar.css,
admin/css/dt/dtform.css,
packages/fileinput/css/fileinput.min.css,
admin/css/fileinput/fileinput.css,
packages/bxslider/jquery.bxslider.css,
assets/global/plugins/jquery-file-upload/blueimp-gallery/blueimp-gallery.min.css';
$this->js = 'admin/js/libraries/form/dtform.js,
packages/fileinput/js/fileinput.min.js,
packages/bxslider/jquery.bxslider.js,
assets/global/plugins/jquery-file-upload/blueimp-gallery/jquery.blueimp-gallery.min.js';
$this->row_source = 'documente_necesare_row_source';
$this->rows_source_sql = "\n\t\t\tSELECT \n\t\t\t\tuploaded_docs.* \n\t\t\tFROM uploaded_docs\n\t\t\t:where:\n\t\t\t:order:\n\t\t\t";
$this->count_filtered_records_sql = "\n\t\t\tSELECT \n\t\t\t\tCOUNT(*) as cnt \n\t\t\tFROM uploaded_docs \n\t\t\t:where:\n\t\t\t";
$this->count_total_records_sql = "\n\t\t\tSELECT \n\t\t\t\tCOUNT(*) as cnt \n\t\t\tFROM uploaded_docs\n\t\t\t";
$this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-right', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:5%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'nume', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Nume fişier', 'style' => 'width:55%'], 'type' => 'view', 'source' => 'banci.documente_necesare.~file_name'], '3' => ['id' => 'created_at', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Data creării', 'style' => 'width:15%'], 'type' => 'field-date-time', 'source' => 'created_at'], '4' => ['id' => 'size', 'orderable' => 'yes', 'class' => 'td-align-right', 'visible' => 'yes', 'header' => ['caption' => 'Mărime', 'style' => 'width:10%'], 'type' => 'field-file-size', 'source' => 'file_size'], '5' => ['id' => 'type', 'orderable' => 'yes', 'class' => 'td-align-center', 'visible' => 'yes', 'header' => ['caption' => 'Tip fişier', 'style' => 'width:10%'], 'type' => 'view', 'source' => 'banci.documente_necesare.~file_type'], '6' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-center td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acţiuni', 'style' => 'width:5%'], 'type' => 'view', 'source' => 'banci.documente_necesare.~actions']];
$this->fields = ['fields' => '', 'searchables' => 'uploaded_docs.file_name', 'orderables' => [1 => 'uploaded_docs.file_name', 2 => 'uploaded_docs.file_size', 3 => 'uploaded_docs.file_extension']];
$this->filters = ['deleted' => 'uploaded_docs.deleted_at is null'];
}
public function __construct($id)
{
parent::__construct($id);
$this->view = 'persoane_fizice.prima_casa.index';
$this->icon = 'admin/img/icons/dt/settings.png';
$this->caption = 'Clienti';
$this->head_title = 'Clienti';
$this->toolbar = 'persoane_fizice.prima_casa.toolbar';
$this->name = 'dt';
$this->display_start = 0;
$this->display_length = 10;
$this->default_order = "1,'asc'";
$this->form = 'Credite\\PersoaneFizice\\Form\\PersoaneFiziceForm';
$this->css = 'packages/datatables/css/1.10.4/datatable.css,
packages/datatables/css/1.10.4/dataTables.bootstrap.css,
admin/css/dt/dt.css,
admin/css/dt/toolbar.css,
admin/css/dt/dtform.css,
assets/global/plugins/icheck/skins/all.css,
assets/global/plugins/bootstrap-datepicker/css/datepicker3.css,
assets/global/plugins/bootstrap-select/bootstrap-select.min.css,
assets/global/plugins/select2/select2.css,
assets/global/css/plugins.css
';
/*
packages/datatables/css/1.10.4/datatable.css
packages/datatables/css/1.10.4/dataTables.bootstrap.css
admin/css/dt/dt.css
admin/css/dt/toolbar.css
admin/css/dt/dtform.css
assets/global/plugins/icheck/skins/all.css
assets/global/plugins/bootstrap-datepicker/css/datepicker3.css
assets/global/plugins/bootstrap-select/bootstrap-select.min.css
assets/global/plugins/select2/select2.css
assets/global/css/plugins.css
*/
$this->js = 'admin/js/libraries/form/dtform.js,
assets/global/plugins/icheck/icheck.min.js,
assets/admin/pages/scripts/form-icheck.js,
assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js,
assets/global/plugins/bootstrap-select/bootstrap-select.min.js,
assets/global/plugins/select2/select2.min.js,
assets/global/plugins/bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js,
assets/admin/pages/scripts/components-pickers.js,
assets/admin/pages/scripts/portlet-draggable.js';
$this->row_source = 'persoane-fizice-row-source';
$this->rows_source_sql = 'SELECT
*
FROM persoane_fizice
:where: :order:';
$this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM persoane_fizice :where:';
$this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM persoane_fizice';
$this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'nume', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Nume client', 'style' => 'width:22%'], 'type' => 'field', 'source' => 'nume'], '3' => ['id' => 'prenume', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Prenume client', 'style' => 'width:22%'], 'type' => 'field', 'source' => 'prenume'], '4' => ['id' => 'cnp', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'CNP', 'style' => 'width:22%'], 'type' => 'field', 'source' => 'cnp'], '5' => ['id' => 'email', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'E-mail', 'style' => 'width:23%'], 'type' => 'field', 'source' => 'email'], '6' => ['id' => 'telefon', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Telefon', 'style' => 'width:23%'], 'type' => 'field', 'source' => 'telefon'], '7' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-left td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acţiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'persoane_fizice.prima_casa.~actions']];
$this->fields = ['fields' => '', 'searchables' => 'id, nume, prenume, cnp, telefon', 'orderables' => []];
$this->filters = ['deleted' => 'deleted_at is null'];
}
public function __construct($id)
{
parent::__construct($id);
$this->view = 'banci.produse.index';
$this->icon = 'admin/img/icons/dt/settings.png';
$this->caption = 'Bănci';
$this->toolbar = 'banci.produse.toolbar';
$this->name = 'dt';
$this->display_start = 0;
$this->display_length = 10;
$this->default_order = "1,'asc'";
$this->form = 'Credite\\Banci\\Form\\BanciForm';
$this->css = 'packages/datatables/css/1.10.4/datatable.css,
packages/datatables/css/1.10.4/dataTables.bootstrap.css,
admin/css/dt/dt.css,
admin/css/dt/toolbar.css,
admin/css/dt/dtform.css,
assets/global/plugins/icheck/skins/all.css,
assets/global/plugins/bootstrap-datepicker/css/datepicker3.css,
assets/global/plugins/bootstrap-select/bootstrap-select.min.css,
assets/global/plugins/select2/select2.css,
assets/global/css/plugins.css
';
$this->js = 'admin/js/libraries/form/dtform.js,
assets/global/plugins/icheck/icheck.min.js,
assets/admin/pages/scripts/form-icheck.js,
assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js,
assets/global/plugins/bootstrap-select/bootstrap-select.min.js,
assets/global/plugins/select2/select2.min.js,
assets/global/plugins/bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js,
assets/admin/pages/scripts/components-pickers.js,
assets/admin/pages/scripts/portlet-draggable.js';
$this->row_source = 'banca_produse_row_source';
$this->rows_source_sql = 'SELECT
produse.id as id,
produse.nume
FROM produse LEFT JOIN banca_produs ON banca_produs.id_produs = produse.id
:where: :order:';
$this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM produse LEFT JOIN banca_produs ON banca_produs.id_produs = produse.id :where:';
$this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM produse';
$this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'nume', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Denumire', 'style' => 'width:90%'], 'type' => 'field', 'source' => 'nume'], '3' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-left td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acţiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'banci.produse.~actions']];
$this->fields = ['fields' => '', 'searchables' => 'id, nume', 'orderables' => []];
$this->filters = ['deleted' => 'banca_produs.deleted_at is null'];
}
public function __construct($id)
{
parent::__construct($id);
$this->view = 'banci.produse.conditii.index';
$this->icon = 'admin/img/icons/dt/settings.png';
$this->caption = 'Condiții de eligibilitate';
$this->toolbar = 'banci.produse.conditii.toolbar';
$this->name = 'dt';
$this->display_start = 0;
$this->display_length = 10;
$this->default_order = "1,'asc'";
$this->form = 'Credite\\Banci\\Form\\ConditiiEligibilitateForm';
$this->css = 'packages/datatables/css/1.10.4/datatable.css,
packages/datatables/css/1.10.4/dataTables.bootstrap.css,
admin/css/dt/dt.css,
admin/css/dt/toolbar.css,
admin/css/dt/dtform.css,
assets/global/plugins/icheck/skins/all.css,
assets/global/plugins/bootstrap-datepicker/css/datepicker3.css,
assets/global/plugins/bootstrap-select/bootstrap-select.min.css,
assets/global/plugins/select2/select2.css,
assets/global/css/plugins.css
';
$this->js = 'admin/js/libraries/form/dtform.js,
assets/global/plugins/icheck/icheck.min.js,
assets/admin/pages/scripts/form-icheck.js,
assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js,
assets/global/plugins/bootstrap-select/bootstrap-select.min.js,
assets/global/plugins/select2/select2.min.js,
assets/global/plugins/bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js,
assets/admin/pages/scripts/components-pickers.js,
assets/admin/pages/scripts/portlet-draggable.js';
$this->row_source = 'conditii_eligibilitate_row_source';
$this->rows_source_sql = 'SELECT
*
FROM conditii_eligibilitate
:where: :order:';
$this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM conditii_eligibilitate :where:';
$this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM conditii_eligibilitate';
$this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'created_at', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Data adăugării', 'style' => 'width:12.8%'], 'type' => 'view', 'source' => 'banci.produse.dobanzi.created_at'], '3' => ['id' => 'vechime_munca_actual', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Vechime la locul de munca actual( luni)', 'style' => 'width:12.8%'], 'type' => 'field', 'source' => 'vechime_munca_actual'], '4' => ['id' => 'vechime_munca_total', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Vechime totala in munca (luni)', 'style' => 'width:12.8%'], 'type' => 'field', 'source' => 'vechime_munca_total'], '5' => ['id' => 'venit_minim', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Venit net minim(lei)', 'style' => 'width:12.8%'], 'type' => 'field', 'source' => 'venit_minim'], '6' => ['id' => 'perioada_contractului_munca', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Perioada contractului de munca (determinata/nedeterminata)', 'style' => 'width:12.8%'], 'type' => 'field', 'source' => 'perioada_contractului_munca'], '7' => ['id' => 'varsta_minima', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Varsta minima (18 ani)', 'style' => 'width:12.8%'], 'type' => 'field', 'source' => 'varsta_minima'], '8' => ['id' => 'varsta_maxima', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Varsta maxima (70 ani)', 'style' => 'width:12.8%'], 'type' => 'field', 'source' => 'varsta_maxima'], '9' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-left td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acţiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'banci.produse.conditii.~actions']];
$this->fields = ['fields' => '', 'searchables' => 'id, nume', 'orderables' => []];
$this->filters = ['deleted' => 'deleted_at is null'];
}
public function __construct($id)
{
parent::__construct($id);
$this->view = 'banci.produse.dobanzi.index';
$this->icon = 'admin/img/icons/dt/settings.png';
$this->caption = 'Dobânzi și comisioane';
$this->toolbar = 'banci.produse.dobanzi.toolbar';
$this->name = 'dt';
$this->display_start = 0;
$this->display_length = 10;
$this->default_order = "1,'asc'";
$this->form = 'Credite\\Banci\\Form\\DobanziComisioaneForm';
$this->css = 'packages/datatables/css/1.10.4/datatable.css,
packages/datatables/css/1.10.4/dataTables.bootstrap.css,
admin/css/dt/dt.css,
admin/css/dt/toolbar.css,
admin/css/dt/dtform.css,
assets/global/plugins/icheck/skins/all.css,
assets/global/plugins/bootstrap-datepicker/css/datepicker3.css,
assets/global/plugins/bootstrap-select/bootstrap-select.min.css,
assets/global/plugins/select2/select2.css,
assets/global/css/plugins.css
';
$this->js = 'admin/js/libraries/form/dtform.js,
assets/global/plugins/icheck/icheck.min.js,
assets/admin/pages/scripts/form-icheck.js,
assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js,
assets/global/plugins/bootstrap-select/bootstrap-select.min.js,
assets/global/plugins/select2/select2.min.js,
assets/global/plugins/bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js,
assets/admin/pages/scripts/components-pickers.js,
assets/admin/pages/scripts/portlet-draggable.js';
$this->row_source = 'dobanzi_comisioane_row_source';
$this->rows_source_sql = 'SELECT
*
FROM dobanzi_comisioane
:where: :order:';
$this->count_filtered_records_sql = 'SELECT COUNT(*) as cnt FROM dobanzi_comisioane :where:';
$this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM dobanzi_comisioane';
$this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:3%'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'created_at', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Data adăugării', 'style' => 'width:12%'], 'type' => 'view', 'source' => 'banci.produse.dobanzi.created_at'], '3' => ['id' => 'dobanda_fixa_std_lei', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Dobanda fixa (lei)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'dobanda_fixa_std_lei'], '4' => ['id' => 'dobanda_fixa_std_eur', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Dobanda fixa (euro)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'dobanda_fixa_std_eur'], '5' => ['id' => 'dobanda_fixa_preferentiala_lei', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Dobanda fixa pref (lei)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'dobanda_fixa_preferentiala_lei'], '6' => ['id' => 'dobanda_fixa_preferentiala_eur', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'obanda fixa pref (eur)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'dobanda_fixa_preferentiala_eur'], '7' => ['id' => 'marja_fixa_std_lei', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Marja fixa std (lei)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'marja_fixa_std_lei'], '8' => ['id' => 'marja_fixa_std_eur', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Marja fixa std (eur)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'marja_fixa_std_eur'], '9' => ['id' => 'marja_fixa_preferentiala_lei', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Marja fixa pref (lei)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'marja_fixa_preferentiala_lei'], '10' => ['id' => 'marja_fixa_preferentiala_eur', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Marja fixa pref (eur)', 'style' => 'width:12%'], 'type' => 'field', 'source' => 'marja_fixa_preferentiala_eur'], '11' => ['id' => 'action', 'orderable' => 'no', 'class' => 'td-align-left td-actions', 'visible' => 'yes', 'header' => ['caption' => 'Acţiuni', 'style' => 'width:7%'], 'type' => 'view', 'source' => 'banci.produse.conditii.~actions']];
$this->fields = ['fields' => '', 'searchables' => 'id, nume', 'orderables' => []];
$this->filters = ['deleted' => 'deleted_at is null'];
}
public function __construct($id)
{
parent::__construct($id);
$this->view = 'users.lista.index';
$this->icon = NULL;
$this->caption = 'Lista utilizatorilor';
$this->toolbar = 'users.lista.toolbar';
$this->name = 'dt';
$this->display_start = 0;
$this->display_length = 25;
$this->default_order = "0,'asc'";
$this->form = NULL;
$this->css = 'admin/css/dt/dt.css, admin/css/dt/toolbar.css, admin/css/dt/dtform.css';
$this->js = 'admin/js/libraries/form/dtform.js';
$this->row_source = 'grid-utilizatori-row-source';
$this->rows_source_sql = '
SELECT
users.*,
organizatii.denumire as organizatie_denumire,
organizatii.telefon as organizatie_telefon,
organizatii.fax as organizatie_fax,
organizatii.email as organizatie_email
FROM users
LEFT JOIN organizatii ON users.id_organizatie = organizatii.id
:where: :order:
';
$this->count_filtered_records_sql = '
SELECT
COUNT(*) as cnt
FROM users
LEFT JOIN organizatii ON users.id_organizatie = organizatii.id
:where:
';
$this->count_total_records_sql = 'SELECT COUNT(*) AS cnt FROM users';
$this->columns = ['1' => ['id' => '#', 'orderable' => 'no', 'class' => 'td-record-count td-align-center', 'visible' => 'yes', 'header' => ['caption' => '#', 'style' => 'width:5%;text-align:center'], 'type' => 'row-number', 'source' => 'row-number'], '2' => ['id' => 'nume-prenume', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Numele şi prenumele', 'style' => 'width:15%;text-align:left'], 'type' => 'view', 'source' => 'users.lista.~nume'], '3' => ['id' => 'email', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Email', 'style' => 'width:15%;text-align:left'], 'type' => 'field', 'source' => 'email'], '4' => ['id' => 'telefon', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Telefon', 'style' => 'width:15%;text-align:left'], 'type' => 'field', 'source' => 'telefon'], '5' => ['id' => 'organizatie', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Organizatie', 'style' => 'width:50%;text-align:left'], 'type' => 'view', 'source' => 'users.lista.~organizatie'], '6' => ['id' => 'actions', 'orderable' => 'yes', 'class' => 'td-align-left', 'visible' => 'yes', 'header' => ['caption' => 'Organizatie', 'style' => 'width:50%;text-align:left'], 'type' => 'view', 'source' => 'users.lista.~actions']];
$this->fields = ['fields' => '', 'searchables' => '', 'orderables' => []];
$this->filters = [];
}
