ApPHP DataGrid Wizard :: Code Editor

Edit Assistance :: Models (a_models.php)

[ Switch to Wizard ] [ : Back ]
Code: * <?php header('content-type: text/html; charset=utf-8'); session_start(); $md_mode = isset($_REQUEST['md_mode']) ? strip_tags($_REQUEST['md_mode']) : ''; $md_key = isset($_REQUEST['md_key']) ? strip_tags($_REQUEST['md_key']) : ''; define ('DATAGRID_DIR', '../modules/datagrid/'); require_once(DATAGRID_DIR.'datagrid.class.php'); $DB_TYPE='mysql'; $DB_HOST='localhost'; $DB_NAME='intifad_assista'; $DB_USER='intifad_admin'; $DB_PASS='Hamza@190820'; ob_start(); $debug_mode = false; $messaging = true; $unique_prefix = 'models_'; $dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix); $dgrid->SetAutocommit(false); $dgrid->SetDbSchema(''); $dg_encoding = 'utf8'; $dg_collation = 'utf8_unicode_ci'; $dgrid->SetEncoding($dg_encoding, $dg_collation); $sql = 'SELECT models.model_id, brands.brand_name, models.model_name, models.brand_id, models.model_area, models.model_term, models.model_franchise_fee, models.model_estimate, models.model_income, models.model_royalty, models.model_employee_doc FROM models INNER JOIN brands ON brands.brand_id=models.brand_id'; $default_order = array('brand_name'=>'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 = 'Models'; $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'=>'enum','view_type'=>'dropdownlist','table'=>'brands','field'=>'brand_id','field_view'=>'brand_name','default_operator'=>'=','case_sensitive'=>'false','comparison_type'=>'string',), 'Model'=>array('type'=>'textbox','view_type'=>'','table'=>'models','field'=>'model_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',), 'model_name'=>array('header'=>'Model','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'model_area'=>array('header'=>'Area (Sq. Ft.)','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'model_term'=>array('header'=>'Term','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'model_franchise_fee'=>array('header'=>'Franchise Fee','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'model_estimate'=>array('header'=>'Estimate','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'model_income'=>array('header'=>'Income','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'model_royalty'=>array('header'=>'BDF','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 = 'models'; $primary_key = 'model_id'; $condition = ''; $dgrid->SetTableEdit($table_name, $primary_key, $condition); $em_columns = array( 'model_name'=>array('header'=>'Model','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'brand_id'=>array('header'=>'Brand','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'model_area'=>array('header'=>'Area (Sq. Ft.)','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'0.00',), 'model_term'=>array('header'=>'Term','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'0',), 'model_franchise_fee'=>array('header'=>'Franchise Fee','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'0.00',), 'model_estimate'=>array('header'=>'Estimate','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'0.00',), 'model_income'=>array('header'=>'Income','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'0.00',), 'model_royalty'=>array('header'=>'BDF','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'0.00',), 'model_employee_doc'=>array('header'=>'Model Employee Doc','visible'=>'true','type'=>'file','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'','target_path'=>'uploads/models/','image_width'=>'','image_height'=>'',), ); $dgrid->SetColumnsInEditMode($em_columns); $auto_column_in_edit_mode = false; $dgrid->SetAutoColumnsInEditMode($auto_column_in_edit_mode); $foreign_keys = array( 'brand_id'=>array('table'=>'brands','field_key'=>'brand_id','field_name'=>'brand_name','view_type'=>'dropdownlist','order_type'=>'ASC'), ); $dgrid->SetForeignKeysEdit($foreign_keys); ?> <!doctype html> <html> <head> <meta charset="utf-8"> <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> <title>Site :: Home</title> <?php $dgrid->WriteCssClass(); ?> </head> <body> <?php if($md_mode == '' && $md_key == ''){ $dgrid->Bind(); ob_end_flush(); }else{ } echo $dg_footer; ?> </body> </html>
[ Switch to Wizard ] [ : Back ]

MENU

Edit Assistance :: Models (a_models.php)