MENU

• : Back

Edit Assistance :: Users (a_users.php)

[ Switch to Wizard ]  [ : Back ]
Code: * <?php // we need this if we want to prevent FF sending double request header('content-type: text/html; charset=utf-8'); ## uncomment, if your want to prevent 'Web Page exired' message when use $submission_method = 'post'; ## (don't uncomment, if your export feature is active) // session_cache_limiter ('private, must-revalidate'); // Initialize the session. session_start(); /*** * Uncomment all needed lines of the code * --------------------- * NOTE: We use * ## as comments * // as lines, that must be uncommented * /// as lines, that may be uncommented (optional) * */ /*** * Common notes * --------------------- * 1. Please, use a $debug_mode = true; before you say 'Why Nothing Works ?!' * 2. Do not put DataGrid code into another HTML form: <form>...</form> * 3. Be careful when using the names of fields they may be case sensitive! * 4. For the best performance uncomment ob_start(); and ob_end_flush(); functions. * */ $md_mode = isset($_REQUEST['md_mode']) ? strip_tags($_REQUEST['md_mode']) : ''; $md_key = isset($_REQUEST['md_key']) ? strip_tags($_REQUEST['md_key']) : ''; ################################################################################ ## --------------------------------------------------------------------------- # ## ApPHP DataGrid (enabled for Pro versions - 7xx) # ## Last changes : 02.01.2014 # ## Developed by : ApPHP <info@apphp.com> # ## License : GNU LGPL v.3 # ## Site : https://www.apphp.com/php-datagrid/ # ## Copyright : ApPHP DataGrid (c) 2006-2014. All rights reserved. # ## # ################################################################################ ## +---------------------------------------------------------------------------+ ## | 1. Creating & Calling: | ## +---------------------------------------------------------------------------+ ## *** define a relative (virtual) path to datagrid.class.php file ## *** (relatively to the current file) ## *** RELATIVE PATH ONLY *** define ('DATAGRID_DIR', '../modules/datagrid/'); /* Ex.: 'datagrid/' */ require_once(DATAGRID_DIR.'datagrid.class.php'); ## ## *** creating variables that we need for database connection $DB_TYPE='mysql'; $DB_HOST='localhost'; /* usually localhost */ $DB_NAME='intifad_assista'; /* usually like this: prefix_dbName */ $DB_USER='intifad_admin'; /* usually like this: prefix_name */ $DB_PASS='Hamza@190820'; ob_start(); ## *** (don't remove this line!!!) START_DATAGRID ## *** set needed options and create a new class instance $debug_mode = false; /* display SQL statements while processing */ $messaging = true; /* display system messages on a screen */ $unique_prefix = 'user_'; /* prevent overlays - must be started with a letter */ $dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix); $dgrid->SetAutocommit(false); $dgrid->SetDbSchema(''); ## *** set encoding and collation (default: utf8/utf8_unicode_ci) $dg_encoding = 'utf8'; $dg_collation = 'utf8_unicode_ci'; $dgrid->SetEncoding($dg_encoding, $dg_collation); ## *** set data source with required settings ## *** 1. write all fields separated by commas(,) like: field1, field2 etc.. DON'T USE table.* ## *** 2. write the primary key in the first place (MUST BE AUTO-INCREMENT NUMERIC!) $sql = 'SELECT user_id, user_name, user_mobile, user_email, is_inactive FROM users'; ## *** set data source with needed options ## *** first parameter 'PDO' $default_order = array('user_id'=>'asc'); /* Ex.: array('field_1'=>'ASC', 'field_2'=>'DESC') */ $dgrid->DataSource('pdo', $DB_TYPE, $DB_HOST, $DB_NAME, $DB_USER, $DB_PASS, $sql, $default_order); ## ## ## +---------------------------------------------------------------------------+ ## | 2. General Settings: | ## +---------------------------------------------------------------------------+ ## +-- PostBack Submission Method -------------------------(for PRO Version)---+ ## *** defines postback submission method for DataGrid: AJAX, POST(default) or GET $postback_method = 'ajax'; $dgrid->SetPostBackMethod($postback_method); ## ## +-- Cache Settings -------------------------------------(for PRO Version)---+ ## *** make sure your cache/ dir has 755 (write) permissions ## *** define caching parameters: 1st - allow caching or not, 2nd - caching lifetime in minutes /// $dgrid->SetCachingParameters(true, 5); ## *** delete all caching pages (only if needed) /// $dgrid->DeleteCache(); ## ## +-- Languages --------------------------------------------------------------+ ## *** set interface language (default - English) ## *** (ar) - Arabic (bg) - Bulgarian (ca) - Catala (ch) - Chinese ## *** (cz) - Czech (da) - Danish (de) - German (en) - English ## *** (es) - Espanol (fi) - Finnish, Suomi (fr) - Francais (gk) - Greek ## *** (he) - Hebrew (hr) - Bosnian/Croatian (hu) - Hungarian (it) - Italian ## *** (ja) - Japanese (lt) - Lithuanian (nl) - Netherlands/'Vlaams'(Flemish) ## *** (pl) - Polish (pb) - Brazilian Portuguese (ro) - Romanian ## *** (ru) - Russian (se) - Swedish (sr) - Serbian (tr) - Turkish $dg_language = 'en'; $dgrid->SetInterfaceLang($dg_language); ## *** set direction: 'ltr' or 'rtr' (default - 'ltr') $direction = 'ltr'; $dgrid->SetDirection($direction); ## ## +-- Layouts, Templates & CSS -----------------------------------------------+ ## *** datagrid layouts: '0' - tabular(horizontal) - default, '1' - columnar(vertical), '2' - customized ## *** use 'view'=>'0' and 'edit'=>'0' only if you work on the same tables ## *** filter layouts: '0' - tabular(horizontal) - default, '1' - columnar(vertical), '2' - advanced(inline) $layouts = array('view'=>'0', 'edit'=>'1', 'details'=>'1', 'filter'=>'1'); $dgrid->SetLayouts($layouts); /// *** $mode_template = array('header'=>'', 'body'=>'', 'footer'=>''); /// @field_name_1@ - field header /// {field_name_1} - field value /// [ADD][CREATE][EDIT][DELETE][BACK][CANCEL][UPDATE][MULTIROW_CHECKBOX][ROWS_NUMERATION] - allowed elements and operations (must be placed in $template['body'] only) /// $view_template = ''; /// $add_edit_template = ''; /// $details_template = array('header'=>'', 'body'=>'', 'footer'=>''); /// $details_template['header'] = ''; /// $details_template['body'] = '<table><tr><td>{field_name_1}</td><td>{field_name_2}</td></tr><tr><td>[BACK]</td></tr></table>'; /// $details_template['footer'] = ''; /// $dgrid->SetTemplates($view_template, $add_edit_template, $details_template); ## *** set modes operations ('type' => 'link|button|image') ## *** 'view' - view mode, 'edit' - add/edit/details modes, ## *** 'byFieldValue'=>'fieldName' - make the field to be a link to edit mode page $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); ## *** set CSS class for datagrid ## *** 'default|blue|gray|green|pink|empty|x-blue|x-gray|x-green' or your own css style $css_class = 'x-blue'; $dgrid->SetCssClass($css_class); ## *** set DataGrid caption $dg_caption = ''; $dgrid->SetCaption($dg_caption); $dg_footer = ''; ## ## +-- Scrolling --------------------------------------------------------------+ ## *** allow scrolling on datagrid /// $scrolling_option = false; /// $dgrid->AllowScrollingSettings($scrolling_option); ## *** set scrolling settings (optional) /// $scrolling_height = '100px'; /* ex.: '190px' or '190' */ /// $dgrid->SetScrollingSettings($scrolling_height); ## ## +-- Multirow Operations ----------------------------------------------------+ ## *** allow multirow operations $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), /// 'my_operation_name' =>array('view'=>true, 'flag_name'=>'my_flag_name', 'flag_value'=>'my_flag_value', 'tooltip'=>'Do something with selected', 'image'=>'image.gif') ); $dgrid->SetMultirowOperations($multirow_operations); ## ## +-- Passing parameters & setting up other DataGrids ------------------------+ ## *** set variables that used to get access to the page (like: my_page.php?act=34&id=56 etc.) //?// $http_get_vars = array(<HTTP_GET_VARS>); //?// $dgrid->SetHttpGetVars($http_get_vars); ## *** set other datagrid/s unique prefixes (if you use few datagrids on one page) ## *** format (in which mode to allow processing of another datagrids) ## *** array('unique_prefix'=>array('view'=>true|false, 'edit'=>true|false, 'details'=>true|false)); /// $anotherDatagrids = array('abcd_'=>array('view'=>true, 'edit'=>true, 'details'=>true)); /// $dgrid->SetAnotherDatagrids($anotherDatagrids); ## ## ## +---------------------------------------------------------------------------+ ## | 3. Printing & Exporting Settings: | ## +---------------------------------------------------------------------------+ ## *** set printing option: true(default) or false $printing_option = false; $dgrid->AllowPrinting($printing_option); ## *** initialize the session with session_start(); ## *** default exporting directory (requires write permissions): tmp/export/ $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); ## ## ## +---------------------------------------------------------------------------+ ## | 4. Sorting & Paging Settings: | ## +---------------------------------------------------------------------------+ ## *** set sorting option: true(default) or false $sorting_option = true; $dgrid->AllowSorting($sorting_option); ## *** set paging option: true(default) or false $paging_option = true; $rows_numeration = false; $numeration_sign = 'N #'; $dropdown_paging = true; $dgrid->AllowPaging($paging_option, $rows_numeration, $numeration_sign, $dropdown_paging); ## *** set paging settings $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); ## ## ## +---------------------------------------------------------------------------+ ## | 5. Filter Settings: | ## +---------------------------------------------------------------------------+ ## *** set filtering option: true or false(default) $filtering_option = true; $show_search_type = true; $dgrid->AllowFiltering($filtering_option, $show_search_type); ## *** set additional filtering settings ## *** use ',' (comma) if you want to make search by some words, for ex.: hello, bye, hi ## *** you have to change search type to OR when you search multi-fields, for ex.: 'first_name, last_name' ## *** 'field_type' (optional, for range search) may be 'from' or 'to' ## *** 'date_format' may be 'date|datedmy|datemdy|datetime|time' ## *** 'default_operator' may be =|<|>|like|%like|like%|%like%|not like ## *** 'handler'=>'' - write here path relatively to DATAGRID_DIR (where datagrid.class.php is found) ## *** 'field_view'=>'fieldName_2' or 'field_view'=>'CONCAT(first_name, ' ', last_name) as full_name' /// $fill_from_array = array('0'=>'No', '1'=>'Yes'); /* as 'value'=>'option' */ $filtering_fields = array( 'Name'=>array('type'=>'textbox','view_type'=>'','table'=>'users','field'=>'user_name','field_view'=>'','default_operator'=>'%like%','case_sensitive'=>'false','comparison_type'=>'string',), 'Mobile'=>array('type'=>'textbox','view_type'=>'','table'=>'users','field'=>'user_mobile','field_view'=>'','default_operator'=>'%like%','case_sensitive'=>'false','comparison_type'=>'string',), 'Email'=>array('type'=>'textbox','view_type'=>'','table'=>'users','field'=>'user_email','field_view'=>'','default_operator'=>'%like%','case_sensitive'=>'false','comparison_type'=>'string',), /// 'Caption_1'=>array('type'=>'textbox', 'table'=>'tableName_1', 'field'=>'fieldName_1|,fieldName_2', 'filter_condition'=>'', 'show_operator'=>'false', 'default_operator'=>'=', 'case_sensitive'=>'false', 'comparison_type'=>'string|numeric|binary', 'width'=>'', 'on_js_event'=>'', 'default'=>''), /// 'Caption_2'=>array('type'=>'textbox', 'table'=>'tableName_2', 'field'=>'fieldName_1|,fieldName_2', 'filter_condition'=>'', 'show_operator'=>'false', 'default_operator'=>'=', 'case_sensitive'=>'false', 'comparison_type'=>'string|numeric|binary', 'width'=>'', 'on_js_event'=>'', 'default'=>'', 'autocomplete'=>'false', 'handler'=>'modules/autosuggest/test.php', 'maxresults'=>'12', 'shownoresults'=>'false'), /// 'Caption_3'=>array('type'=>'enum', 'table'=>'tableName_3', 'field'=>'fieldName_1', 'filter_condition'=>'', 'show_operator'=>'false', 'default_operator'=>'=', 'case_sensitive'=>'false', 'comparison_type'=>'string|numeric|binary', 'width'=>'', 'on_js_event'=>'', 'default'=>'', 'source'=>'self'|$fill_from_array, 'view_type'=>'dropdownlist(default)|radiobutton', 'field_view'=>'fieldName_2', 'order_by_field'=>'', 'order_type'=>'ASC|DESC', 'condition'=>'', 'show_count'=>false, 'multiple'=>'false', 'multiple_size'=>'4'), /// 'Caption_4'=>array('type'=>'calendar', 'table'=>'tableName_4', 'field'=>'fieldName_1', 'filter_condition'=>'', 'show_operator'=>'false', 'default_operator'=>'=', 'case_sensitive'=>'false', 'comparison_type'=>'string|numeric|binary', 'width'=>'', 'on_js_event'=>'', 'default'=>'', 'calendar_type'=>'popup|floating', 'date_format'=>'date', 'field_type'=>''), ); $dgrid->SetFieldsFiltering($filtering_fields); ## *** allow default filtering: default - false /// $default_filtering_option = true; /// $dgrid->AllowDefaultFiltering($default_filtering_option); ## ## ## +---------------------------------------------------------------------------+ ## | 6. View Mode Settings: | ## +---------------------------------------------------------------------------+ ## *** set view mode table properties $vm_table_properties = array('width'=>'95%'); $dgrid->SetViewModeTableProperties($vm_table_properties); ## *** set columns in view mode ## *** Ex.: 'on_js_event'=>'onclick="alert('Yes!!!');"' ## *** 'barchart' : number format in SELECT SQL must be equal with number format in max_value /// $fill_from_array = array('0'=>'Banned', '1'=>'Active', '2'=>'Closed', '3'=>'Removed'); /* as 'value'=>'option' */ $vm_columns = array( 'user_name'=>array('header'=>'Name','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'user_mobile'=>array('header'=>'Mobile','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'user_email'=>array('header'=>'Email','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'is_inactive'=>array('header'=>'Is Inactive','visible'=>'true','type'=>'checkbox','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false','true_value'=>1,'false_value'=>0,), /// 'FieldName_1'=>array('header'=>'Name_A', 'type'=>'label', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_2'=>array('header'=>'Name_B', 'type'=>'image', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'target_path'=>'uploads/', 'default'=>'', 'image_width'=>'50px', 'image_height'=>'30px', 'linkto'=>'', 'magnify'=>'false', 'magnify_type'=>'popup|magnifier|lightbox', 'magnify_power'=>'2'), /// 'FieldName_3'=>array('header'=>'Name_C', 'type'=>'linktoview', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_4'=>array('header'=>'Name_D', 'type'=>'linktoedit', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_5'=>array('header'=>'Name_E', 'type'=>'linktodelete', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_6'=>array('header'=>'Name_F', 'type'=>'link', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'field_key'=>'field_name_0', 'field_key_1'=>'field_name_1', 'field_data'=>'field_name_2', 'rel'=>'', 'title'=>'', 'target'=>'_self', 'href'=>'{0}'), /// 'FieldName_7'=>array('header'=>'Name_G', 'type'=>'link', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'field_key'=>'field_name_0', 'field_key_1'=>'field_name_1', 'field_data'=>'field_name_2', 'rel'=>'', 'title'=>'', 'target'=>'_self', 'href'=>'mailto:{0}'), /// 'FieldName_8'=>array('header'=>'Name_H', 'type'=>'link', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'field_key'=>'field_name_0', 'field_key_1'=>'field_name_1', 'field_data'=>'field_name_2', 'rel'=>'', 'title'=>'', 'target'=>'_self', 'href'=>'http://example.com?act={0}&act={1}&code=ABC'), /// 'FieldName_9'=>array('header'=>'Name_I', 'type'=>'linkbutton', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'field_key'=>'field_name_0', 'field_key_1'=>'field_name_1', 'field_data'=>'field_name_2', 'href'=>'{0}'), /// 'FieldName_10'=>array('header'=>'Name_G', 'type'=>'money', 'align'=>'right','width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'sign'=>'$', 'sign_place'=>'before|after', 'decimal_places'=>'2', 'dec_separator'=>'.', 'thousands_separator'=>','), /// 'FieldName_11'=>array('header'=>'Name_K', 'type'=>'password', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'hide'=>'false'), /// 'FieldName_12'=>array('header'=>'Name_L', 'type'=>'percent', 'align'=>'right','width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'decimal_places'=>'2', 'dec_separator'=>'.'), /// 'FieldName_13'=>array('header'=>'Name_M', 'type'=>'barchart', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'field'=>'', 'value_sign'=>'', 'minimum_color'=>'', 'minimum_value'=>'', 'middle_color'=>'', 'middle_value'=>'', 'maximum_color'=>'', 'maximum_value'=>'100', 'display_type'=>'vertical|horizontal'), /// 'FieldName_14'=>array('header'=>'Name_N', 'type'=>'enum', 'align'=>'left', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'summarize'=>'false', 'summarize_sign'=>'', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'source'=>$fill_from_array, 'multiple'=>'false'), /// 'FieldName_15'=>array('header'=>'Name_O', 'type'=>'color', 'align'=>'center', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'text_length'=>'-1', 'tooltip'=>'false', 'tooltip_type'=>'floating|simple', 'case'=>'normal|upper|lower|camel', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'view_type'=>'text|image'), /// 'FieldName_16'=>array('header'=>'Name_P', 'type'=>'checkbox', 'align'=>'center', 'width'=>'X%|Xpx', 'wrap'=>'wrap|nowrap', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>'', 'true_value'=>1, 'false_value'=>0), /// 'FieldName_17'=>array('header'=>'Name_Q', 'type'=>'object', 'align'=>'center', 'width'=>'X%|Xpx', 'height'=>'X%|Xpx', 'sort_type'=>'string|numeric', 'sort_by'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_18'=>array('header'=>'Name_R', 'type'=>'blob'), ); $dgrid->SetColumnsInViewMode($vm_columns); ## *** set auto-generated columns in view mode $auto_column_in_view_mode = false; $dgrid->SetAutoColumnsInViewMode($auto_column_in_view_mode); ## ## ## +---------------------------------------------------------------------------+ ## | 7. Add/Edit/Details Mode Settings: | ## +---------------------------------------------------------------------------+ ## *** set add/edit mode table properties $em_table_properties = array('width'=>'80%'); $dgrid->SetEditModeTableProperties($em_table_properties); ## *** set details mode table properties $dm_table_properties = array('width'=>'80%'); $dgrid->SetDetailsModeTableProperties($dm_table_properties); ## *** set settings for add/edit/details modes $table_name = 'users'; $primary_key = 'user_id'; // for ex.: 'table_name.field = '.$_REQUEST['abc_rid']; $condition = ''; $dgrid->SetTableEdit($table_name, $primary_key, $condition); ## *** set columns in edit mode ## *** first letter: r - required, s - simple (not required) ## *** second letter: t - text(including datetime), n - numeric, a - alphabetic, e - email, f - float, ## y - any(generally used for foreign languages), l - login name, z - zipcode, ## p - password, i - integer, v - verified, c - checked (for checkboxes), u - URL ## s - SSN number, m - telephone, b - alphanumeric, r - checked (for radiobuttons) ## x - template (for example - 'req_type'='rx', 'template'=>'(ddd)-ddd-dd-dd', where d - digit, c - character) ## *** third letter (optional): ## for numbers: s - signed, u - unsigned, p - positive, n - negative ## for strings: u - upper, l - lower, n - normal, y - any ## for telephone: m - mobile, f - fixed (stationary), i - international, y - any ## *** Ex.: 'on_js_event'=>'onclick="alert('Yes!!!');"' ## *** Ex.: type = textbox|textarea|label|date|datedmy|datemdy|datetime|datetimedmy|datetimemdy|time|image|password|enum|print|checkbox|blob|hidden|validator ## *** Format for date: yyyy-mm-dd, datedmy: dd-mm-yyyy, datemdy: mm-dd-yyyy, time: hh:mm:ss etc. ## *** make sure your WYSIWYG directory has 755 access permissions ## *** make sure uploading directories for files/images have 755 access permissions ## *** to set up uploading directory for textarea, open modules\wysiwyg\addons\imagelibrary\config.inc.php and change $imagebasedir = 'images'; ## *** if you allows user upload files via WYSIWYG - make sure the area this script is already password protected!!! /// $fill_from_array = array('0'=>'No', '1'=>'Yes', '2'=>'Don't know', '3'=>'My be'); /* as 'value'=>'option' */ $em_columns = array( 'user_name'=>array('header'=>'Name','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ry','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'user_mobile'=>array('header'=>'Mobile','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ry','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'user_email'=>array('header'=>'Email','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'re','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'user_password'=>array('header'=>'Password','visible'=>'false','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sp','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'vendor_id'=>array('header'=>'Vendor','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'vendor_type_id'=>array('header'=>'Type','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'is_inactive'=>array('header'=>'Is Inactive','visible'=>'true','type'=>'checkbox','align'=>'left','width'=>'','req_type'=>'sy','true_value'=>1, 'false_value'=>0,'maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'user_created_on'=>array('header'=>'Created On','visible'=>'true','type'=>'label','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'user_modified_on'=>array('header'=>'Modified On','visible'=>'true','type'=>'label','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), /// 'FieldName_1' =>array('header'=>'Name_A', 'type'=>'textbox', 'req_type'=>'rt', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_2' =>array('header'=>'Name_B', 'type'=>'textarea', 'req_type'=>'rt', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'edit_type'=>'simple|wysiwyg', 'resizable'=>'false', 'upload_images'=>'false', 'rows'=>'7', 'cols'=>'50'), /// 'FieldName_3' =>array('header'=>'Name_C', 'type'=>'label', 'title'=>'', 'default'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_4' =>array('header'=>'Name_D', 'type'=>'date', 'req_type'=>'rt', 'width'=>'187px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'calendar_type'=>'popup|floating|dropdownlist'), /// 'FieldName_5' =>array('header'=>'Name_E', 'type'=>'datetime', 'req_type'=>'st', 'width'=>'187px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'calendar_type'=>'popup|floating|dropdownlist', 'show_seconds'=>'true'), /// 'FieldName_6' =>array('header'=>'Name_F', 'type'=>'time', 'req_type'=>'st', 'width'=>'90px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'calendar_type'=>'popup|dropdownlist', 'show_seconds'=>'true'), /// 'FieldName_7' =>array('header'=>'Name_G', 'type'=>'image', 'req_type'=>'st', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'target_path'=>'uploads/', 'allow_image_updating'=>'false', 'max_file_size'=>'100000|100K|10M|1G', 'image_width'=>'120px', 'image_height'=>'90px', 'resize_dir'=>'down|up|both', 'resize_image'=>'false', 'resize_width'=>'', 'resize_height'=>'', 'magnify'=>'false', 'magnify_type'=>'popup|magnifier|lightbox', 'magnify_power'=>'2', 'file_name'=>'', 'host'=>'local|remote', 'allow_downloading'=>'false', 'allowed_extensions'=>''), /// 'FieldName_8' =>array('header'=>'Name_H', 'type'=>'password', 'req_type'=>'rp', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'hide'=>'false', 'generate'=>'true', 'cryptography'=>'false', 'cryptography_type'=>'aes|md5', 'aes_password'=>'aes_password'), /// 'FieldName_9' =>array('header'=>'Name_I', 'type'=>'money', 'req_type'=>'rn', 'width'=>'80px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'sign'=>'$', 'sign_place'=>'before|after', 'decimal_places'=>'2', 'dec_separator'=>'.', 'thousands_separator'=>','), /// 'FieldName_10' =>array('header'=>'Name_J', 'type'=>'enum', 'req_type'=>'st', 'width'=>'', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'source'=>'self'|$fill_from_array, 'view_type'=>'dropdownlist(default)|radiobutton|checkbox', 'radiobuttons_alignment'=>'horizontal|vertical', 'multiple'=>'false', 'multiple_size'=>'4'), /// 'FieldName_11' =>array('header'=>'Name_K', 'type'=>'print', 'req_type'=>'st', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_12' =>array('header'=>'Name_L', 'type'=>'checkbox', 'req_type'=>'st', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'true_value'=>1, 'false_value'=>0), /// 'FieldName_13' =>array('header'=>'Name_M', 'type'=>'file', 'req_type'=>'st', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'target_path'=>'uploads/', 'max_file_size'=>'100000|100K|10M|1G', 'file_name'=>'', 'host'=>'local|remote', 'allow_downloading'=>'false', 'allowed_extensions'=>''), /// 'FieldName_14_a' =>array('header'=>'Name_N (for add/edit mode)', 'type'=>'link', 'req_type'=>'st', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>''), /// 'FieldName_14_b' =>array('header'=>'Name_N (for details mode)', 'type'=>'link', 'req_type'=>'st', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'field_key'=>'', 'field_key_1'=>'', 'field_data'=>'', 'rel'=>'', 'title'=>'', 'target'=>'_self', 'href'=>'{0}'), /// 'FieldName_15' =>array('header'=>'Name_O', 'type'=>'foreign_key','req_type'=>'ri', 'width'=>'', 'title'=>'', 'readonly'=>'false', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true'), /// 'FieldName_16' =>array('header'=>'Name_P', 'type'=>'blob', 'req_type'=>'st', 'readonly'=>'false'), /// 'FieldName_17' =>array('header'=>'Name_Q', 'type'=>'hidden', 'req_type'=>'st', 'default'=>'', 'value'=>'', 'unique'=>'false', 'visible'=>'true'), /// 'FieldName_18' =>array('header'=>'Name_R', 'type'=>'percent', 'req_type'=>'rt', 'width'=>'80px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'decimal_places'=>'2', 'dec_separator'=>'.'), /// 'FieldName_19' =>array('header'=>'Name_S', 'type'=>'color', 'req_type'=>'rt', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'unique'=>'false', 'unique_condition'=>'', 'visible'=>'true', 'on_js_event'=>'', 'view_type'=>'dropdownlist|picker', 'save_format'=>'hexcodes'), /// 'validator' =>array('header'=>'Name_T', 'type'=>'validator', 'req_type'=>'rv', 'width'=>'210px', 'title'=>'', 'readonly'=>'false', 'maxlength'=>'-1', 'default'=>'', 'visible'=>'true', 'on_js_event'=>'', 'for_field'=>'', 'validation_type'=>'password|email'), /// 'delimiter_1|2|3...' =>array('inner_html'=>'<br />'), ); $dgrid->SetColumnsInEditMode($em_columns); ## *** set auto-generated columns in edit mode $auto_column_in_edit_mode = false; $dgrid->SetAutoColumnsInEditMode($auto_column_in_edit_mode); ## ## ## +---------------------------------------------------------------------------+ ## | 8. Foreign Keys Settings: | ## +---------------------------------------------------------------------------+ ## *** set foreign keys for add/edit/details modes (if there are linked tables) ## *** Ex.: 'field_name'=>'CONCAT(field1," ",field2) as field3' ## *** Ex.: 'condition'=>'TableName_1.FieldName > 'a' AND TableName_1.FieldName < 'c'' ## *** Ex.: 'on_js_event'=>'onclick="alert('Yes!!!');"' $foreign_keys = array( 'vendor_id'=>array('table'=>'vendors','field_key'=>'vendor_id','field_name'=>'vendor_name','view_type'=>'dropdownlist','order_type'=>'ASC'), 'vendor_type_id'=>array('table'=>'vendors_type','field_key'=>'vendor_type_id','field_name'=>'vendor_type_name','view_type'=>'dropdownlist','order_type'=>'ASC'), /// 'ForeignKey_1'=>array('table'=>'TableName_1', 'field_key'=>'FieldKey_1', 'field_name'=>'FieldName_1', 'view_type'=>'dropdownlist(default)|radiobutton|textbox|label', 'radiobuttons_alignment'=>'horizontal|vertical', 'condition'=>'', 'order_by_field'=>'', 'order_type'=>'ASC|DESC', 'show_count'=>'', 'on_js_event'=>''), /// 'ForeignKey_2'=>array('table'=>'TableName_2', 'field_key'=>'FieldKey_2', 'field_name'=>'FieldName_2', 'view_type'=>'dropdownlist(default)|radiobutton|textbox|label', 'radiobuttons_alignment'=>'horizontal|vertical', 'condition'=>'', 'order_by_field'=>'', 'order_type'=>'ASC|DESC', 'show_count'=>'', 'on_js_event'=>'') ); $dgrid->SetForeignKeysEdit($foreign_keys); ## *** (don't remove this line!!!) END_DATAGRID ################################################################################ ?> <!doctype html> <html> <head> <meta charset="utf-8"> <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> <title>Site :: Home</title> <?php ## call of this method between HTML <HEAD> tags $dgrid->WriteCssClass(); ?> </head> <body> <?php ################################################################################ ## +---------------------------------------------------------------------------+ ## | 9. Bind the DataGrid: | ## +---------------------------------------------------------------------------+ ## *** bind the DataGrid and draw it on the screen ## *** you may use $dgrid->Bind(false) and then $dgrid->Show() to separate ## *** binding and displaying id datagrid if($md_mode == '' && $md_key == ''){ $dgrid->Bind(); ob_end_flush(); }else{ } ################################################################################ echo $dg_footer; ?> </body> </html>
[ Switch to Wizard ]  [ : Back ]