MENU
:
Back
Edit Assistance :: Brands (a_brands.php)
[ Switch to Wizard
]
[ : Back ]
Code:
*
SetAutocommit(false); $dgrid->SetDbSchema(''); $dg_encoding = 'utf8'; $dg_collation = 'utf8_general_ci'; $dgrid->SetEncoding($dg_encoding, $dg_collation); $sql = 'SELECT brand_id, brand_name, brand_bank_name, brand_bank_branch, brand_bank_account, brand_bank_account_type, brand_bank_account_ifsc, brand_bank_account_upi, brand_proposal_doc FROM brands'; $default_order = array('brand_id'=>'asc'); $dgrid->DataSource('pdo', $DB_TYPE, $DB_HOST, $DB_NAME, $DB_USER, $DB_PASS, $sql, $default_order); $postback_method = 'ajax'; $dgrid->SetPostBackMethod($postback_method); $dg_language = 'en'; $dgrid->SetInterfaceLang($dg_language); $direction = 'ltr'; $dgrid->SetDirection($direction); $layouts = array('view'=>'0', 'edit'=>'1', 'details'=>'1', 'filter'=>'1'); $dgrid->SetLayouts($layouts); $modes = array( 'add' =>array('view'=>true, 'edit'=>false, 'type'=>'link', 'show_button'=>true, 'show_add_button'=>'inside|outside'), 'edit' =>array('view'=>true, 'edit'=>true, 'type'=>'link', 'show_button'=>true, 'byFieldValue'=>''), 'details' =>array('view'=>true, 'edit'=>false, 'type'=>'link', 'show_button'=>true), 'delete' =>array('view'=>true, 'edit'=>false, 'type'=>'image', 'show_button'=>true) ); $dgrid->SetModes($modes); $css_class = 'x-blue'; $dgrid->SetCssClass($css_class); $dg_caption = 'Brands'; $dgrid->SetCaption($dg_caption); $dg_footer = ''; $multirow_option = false; $dgrid->AllowMultirowOperations($multirow_option); $multirow_operations = array( 'edit' =>array('view'=>false), 'details' =>array('view'=>false), 'clone' =>array('view'=>false), 'delete' =>array('view'=>false), ); $dgrid->SetMultirowOperations($multirow_operations); $printing_option = false; $dgrid->AllowPrinting($printing_option); $exporting_option = false; $export_all = false; $dgrid->AllowExporting($exporting_option, $export_all); $exporting_types = array('csv'=>'false', 'xls'=>'false', 'pdf'=>'false', 'xml'=>'false'); $dgrid->AllowExportingTypes($exporting_types); $sorting_option = true; $dgrid->AllowSorting($sorting_option); $paging_option = true; $rows_numeration = false; $numeration_sign = 'N #'; $dropdown_paging = true; $dgrid->AllowPaging($paging_option, $rows_numeration, $numeration_sign, $dropdown_paging); $bottom_paging = array('results'=>true, 'results_align'=>'left', 'pages'=>true, 'pages_align'=>'center', 'page_size'=>true, 'page_size_align'=>'right'); $top_paging = array(); $pages_array = array('5'=>'5','10'=>'10','15'=>'15','20'=>'20','25'=>'25','50'=>'50','100'=>'100','250'=>'250','500'=>'500','1000'=>'1000'); $default_page_size = 10; $paging_arrows = array('first'=>'|<<', 'previous'=>'<<', 'next'=>'>>', 'last'=>'>>|'); $dgrid->SetPagingSettings($bottom_paging, $top_paging, $pages_array, $default_page_size, $paging_arrows); $filtering_option = true; $show_search_type = true; $dgrid->AllowFiltering($filtering_option, $show_search_type); $filtering_fields = array( 'Brand'=>array('type'=>'textbox','view_type'=>'','table'=>'brands','field'=>'brand_name','field_view'=>'','default_operator'=>'%like%','case_sensitive'=>'false','comparison_type'=>'string',), ); $dgrid->SetFieldsFiltering($filtering_fields); $vm_table_properties = array('width'=>'95%'); $dgrid->SetViewModeTableProperties($vm_table_properties); $vm_columns = array( 'brand_name'=>array('header'=>'Brand','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_bank_name'=>array('header'=>'Bank','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_bank_branch'=>array('header'=>'Branch','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_bank_account'=>array('header'=>'Account','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_bank_account_type'=>array('header'=>'Type','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_bank_account_ifsc'=>array('header'=>'IFSC','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_bank_account_upi'=>array('header'=>'UPI','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'brand_proposal_doc'=>array('header'=>'Proposal','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), ); $dgrid->SetColumnsInViewMode($vm_columns); $auto_column_in_view_mode = false; $dgrid->SetAutoColumnsInViewMode($auto_column_in_view_mode); $em_table_properties = array('width'=>'80%'); $dgrid->SetEditModeTableProperties($em_table_properties); $dm_table_properties = array('width'=>'80%'); $dgrid->SetDetailsModeTableProperties($dm_table_properties); $table_name = 'brands'; $primary_key = 'brand_id'; $condition = ''; $dgrid->SetTableEdit($table_name, $primary_key, $condition); $em_columns = array( 'brand_name'=>array('header'=>'Brand','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_bank_name'=>array('header'=>'Bank','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_bank_branch'=>array('header'=>'Branch','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_bank_account'=>array('header'=>'Account','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_bank_account_type'=>array('header'=>'Type','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_bank_account_ifsc'=>array('header'=>'IFSC','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_bank_account_upi'=>array('header'=>'UPI','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_proposal_doc'=>array('header'=>'Proposal','visible'=>'true','type'=>'file','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'','target_path'=>'../uploads/brands/','image_width'=>'','image_height'=>'',), ); $dgrid->SetColumnsInEditMode($em_columns); $auto_column_in_edit_mode = false; $dgrid->SetAutoColumnsInEditMode($auto_column_in_edit_mode); ?>
Site :: Home
WriteCssClass(); ?> Bind(); ob_end_flush(); }else{ } echo $dg_footer; ?>
[ Switch to Wizard
]
[ : Back ]