ApPHP DataGrid Wizard :: Code Editor

Edit Assistance :: Opportunities (opportunities.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 = 'opprotuni_'; / 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 opportunities.opportunity_id, opportunities.opportunity_salt, brands.brand_id, brands.brand_name, opportunities.model_id, models.model_name, opportunities.opportunity_name, opportunities.opportunity_mobile, opportunities.opportunity_email, opportunities.opportunity_address, opportunities.city_id, cities.city_name, districts.district_id, districts.district_name, states.state_id, states.state_name, opportunities.opportunity_pincode, opportunities.opportunity_note, opportunities.cordinator_id_sales, sales.cordinator_name AS cordinator_name_sales, opportunities.cordinator_id_accounts, accounts.cordinator_name AS cordinator_name_accounts, opportunities.is_active, opportunities.can_edit, opportunities.opportunity_created_on, opportunities.opportunity_modified_on FROM opportunities INNER JOIN models ON models.model_id=opportunities.model_id LEFT JOIN brands ON brands.brand_id=models.brand_id INNER JOIN cities ON cities.city_id=opportunities.city_id LEFT JOIN districts ON districts.district_id=cities.district_id LEFT JOIN states ON states.state_id=districts.state_id INNER JOIN cordinators sales ON sales.cordinator_id=opportunities.cordinator_id_sales INNER JOIN cordinators accounts ON accounts.cordinator_id=opportunities.cordinator_id_accounts'; ## * set data source with needed options ## *** first parameter 'PDO' $default_order = array('opportunity_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'=>false, '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( 'Model'=>array('type'=>'enum','view_type'=>'dropdownlist','table'=>'models','field'=>'model_id','field_view'=>'model_name','default_operator'=>'=','case_sensitive'=>'false','comparison_type'=>'string',), 'Name'=>array('type'=>'textbox','view_type'=>'','table'=>'opportunities','field'=>'opportunity_name','field_view'=>'','default_operator'=>'%like%','case_sensitive'=>'false','comparison_type'=>'string',), 'Mobile'=>array('type'=>'textbox','view_type'=>'','table'=>'opportunities','field'=>'opportunity_mobile','field_view'=>'','default_operator'=>'%like%','case_sensitive'=>'false','comparison_type'=>'numeric',), 'City'=>array('type'=>'enum','view_type'=>'dropdownlist','table'=>'cities','field'=>'city_id','field_view'=>'city_name','default_operator'=>'=','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( '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',), 'opportunity_name'=>array('header'=>'Name','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'opportunity_mobile'=>array('header'=>'Mobile','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'opportunity_email'=>array('header'=>'Email','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'city_name'=>array('header'=>'City','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'state_name'=>array('header'=>'State','visible'=>'true','type'=>'label','align'=>'left','sortable'=>'true','width'=>'','wrap'=>'nowrap','case'=>'normal','text_length'=>'-1','tooltip'=>'false','summarize'=>'false',), 'is_active'=>array('header'=>'Is Active','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,), 'can_edit'=>array('header'=>'Can Edit','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 = 'opportunities'; $primary_key = 'opportunity_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( 'opportunity_salt'=>array('header'=>'Salt','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ry','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'model_id'=>array('header'=>'Model','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ry','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_name'=>array('header'=>'Name','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ry','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_mobile'=>array('header'=>'Mobile','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ri','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_email'=>array('header'=>'Email','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'re','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_address'=>array('header'=>'Address','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'city_id'=>array('header'=>'City','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'ry','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_pincode'=>array('header'=>'Pincode','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'si','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_note'=>array('header'=>'Notes','visible'=>'true','type'=>'textarea','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'','edit_type'=>'simple', 'rows'=>'7', ), 'cordinator_id_sales'=>array('header'=>'Sales Coordinator','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'cordinator_id_accounts'=>array('header'=>'Accounts Coordinator','visible'=>'true','type'=>'textbox','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'is_active'=>array('header'=>'Is Active','visible'=>'true','type'=>'checkbox','align'=>'left','width'=>'','req_type'=>'sy','true_value'=>1, 'false_value'=>0,'maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'can_edit'=>array('header'=>'Can Edit','visible'=>'true','type'=>'checkbox','align'=>'left','width'=>'','req_type'=>'sy','true_value'=>1, 'false_value'=>0,'maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_created_on'=>array('header'=>'Created On','visible'=>'true','type'=>'label','align'=>'left','width'=>'','req_type'=>'sy','maxlength'=>'-1','readonly'=>'false','unique'=>'false','default'=>'',), 'opportunity_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( 'model_id'=>array('table'=>'models','field_key'=>'model_id','field_name'=>'model_name','view_type'=>'dropdownlist','order_type'=>'ASC'), 'city_id'=>array('table'=>'cities','field_key'=>'city_id','field_name'=>'city_name','view_type'=>'dropdownlist','order_type'=>'ASC'), 'cordinator_id_sales'=>array('table'=>'cordinators','field_key'=>'cordinator_id','field_name'=>'cordinator_name','view_type'=>'dropdownlist','order_type'=>'ASC'), 'cordinator_id_accounts'=>array('table'=>'cordinators','field_key'=>'cordinator_id','field_name'=>'cordinator_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 ]

MENU

Edit Assistance :: Opportunities (opportunities.php)