Advertisement
sirshadow

phpgrid - Dropdown

Mar 2nd, 2014
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.15 KB | None | 0 0
  1. $g = new jqgrid();
  2.     $grid["caption"] = "Circumscripții";
  3.     $grid["autowidth"] = true; // expand grid to screen width
  4.     $grid["multiselect"] = false;
  5.     $grid["height"] = "auto";
  6.    
  7.     $grid["detail_grid_id"] = "circumscriptii_arondate";
  8.     $grid["subgridparams"] = "id,cod";
  9.  
  10.     $g->set_options($grid);
  11.  
  12.     $e["on_insert"] = array("circumscriptie_adauga", null, false);
  13.     $e["on_update"] = array("circumscriptie_editeaza", null, false);
  14.     $g->set_events($e);
  15.    
  16.     $g->table = "circumscriptii";
  17.  
  18.     $g->set_actions(array(
  19.         "add"=>true,
  20.         "edit"=>true,
  21.         "delete"=>false,
  22.         "clone"=>false,
  23.         "rowactions"=>false,
  24.         "search" => "advance",
  25.         "showhidecolumns" => false
  26.         )
  27.     );
  28.  
  29. $out = $g->render("circumscriptii");
  30. // [-] MASTER GRID
  31.    
  32. // [+] DETAIL GRID
  33. $g2 = new jqgrid();
  34.    
  35.     $grid=array(); //clear $grid
  36.     $grid["caption"] = "Arondare circumscripție";
  37.     $grid["height"] = "";
  38.     $grid["autowidth"] = true;
  39.    
  40.     $grid["add_options"]["beforeInitData"] = "function(formid){ var selr = jQuery('#circumscriptii').jqGrid('getGridParam','selrow'); if (!selr) { alert('Selectează întâi o circumscripție!'); return false; } }";
  41.     $g2->set_options($grid);
  42.    
  43.     $_id = intval($_GET["rowid"]);
  44.     $cod = $_GET["cod"];
  45.     $cid = intval($_GET["id"]);
  46.     /// SELECTION OF DETAIL GRIB BASED ON MASTER GRID
  47.     $g2->select_command = "SELECT circumscriptii_arondate.id as id, circumscriptie, cod AS circumscriptie_cod, medic, utilizatori_info.nume as nume, utilizatori_info.prenume as prenume, data_arondare
  48.             FROM circumscriptii_arondate, circumscriptii, utilizatori_info
  49.             WHERE circumscriptii_arondate.circumscriptie = circumscriptii.id
  50.                 AND circumscriptii_arondate.medic = utilizatori_info.utilizator
  51.                 AND circumscriptie={$cid}
  52.             GROUP BY circumscriptii_arondate.id";
  53.     $g2->table = "circumscriptii_arondate";
  54.    
  55.     $cols = array(); //clear $cols
  56.     $col = array(); //clear $col
  57.     $col["title"] = "Id";
  58.     $col["name"] = "id";
  59.     $col["editable"] = true;
  60.     $col["editoptions"] = array(
  61.             "readonly" => "readonly");
  62.     $col["search"] = false;
  63.     $cols[] = $col;
  64.    
  65.     $col = array();
  66.     $col["title"] = "Circumscriptie";
  67.     $col["name"] = "circumscriptie";
  68.     $col["editable"] = false;
  69.     $col["editoptions"] = array(
  70.             "readonly" => "readonly");
  71.     $col["default"] = $cod;
  72.     $col["search"] = false;
  73.     $cols[] = $col;
  74.  
  75.     $col = array();
  76.     $col["title"] = "Cod circumscripție";
  77.     $col["name"] = "circumscriptie_cod";
  78.     $col["editable"] = false;
  79.     $col["hidden"] = true;
  80.     $col["search"] = false;
  81.     $cols[] = $col;
  82.    
  83.     $col = array(); // HIDE FROM LIST BUT SHOW ON EDIT
  84.     $col["title"] = "Medic";
  85.     $col["name"] = "medic";
  86.     $col["hidden"] = true;
  87.     $col["editable"] = true;
  88.     $col["edittype"] = "select";
  89.     // PROBLEMS IN DROPDOWN
  90.     $str = $g2->get_dropdown_values("SELECT utilizator as k, CONCAT(nume,' ', prenume) as v FROM utilizatori_info
  91.                     WHERE utilizator NOT IN (SELECT id FROM utilizatori WHERE stare<>1)
  92.                         AND utilizator NOT IN (SELECT medic FROM circumscriptii_arondate WHERE circumscriptie=".$cid.")");
  93.     $col["editoptions"] = array("value"=>$str);
  94.     $col["editrules"] = array("edithidden"=>true);
  95.     $cols[] = $col;
  96.    
  97.     $col = array();
  98.     $col["title"] = "Medic arondat";
  99.     $col["name"] = "nume";
  100.     $col["editable"] = false;
  101.     $col["default"] = "<a href=\"#link_catre_medic\">{nume} {prenume}</a>";
  102.     $cols[] = $col;
  103.    
  104.     $col = array(); //this with the above "nume" will be solve with SQL CONCAT
  105.     $col["name"] = "prenume";
  106.     $col["editable"] = false;
  107.     $col["hidden"] = true;
  108.     $cols[] = $col;
  109.    
  110.     $col = array();
  111.     $col["title"] = "Data arondare";
  112.     $col["name"] = "data_arondare";
  113.     $col["align"] = "center";
  114.     $col["formatter"] = "date";
  115.     $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.Y');
  116.     $col["editable"] = false;
  117.     $col["search"] = false;
  118.     $cols[] = $col;
  119.    
  120.     $g2->set_columns($cols);
  121.    
  122.     $e["on_insert"] = array("add_client", null, true);
  123.     $e["on_update"] = array("edit_client", null, false);
  124.     $g2->set_events($e);
  125.    
  126.     $g2->set_actions(array(
  127.             "add"=>true,
  128.             "edit"=>true,
  129.             "delete"=>false,
  130.             "rowactions"=>false,
  131.             "autofilter" => true,
  132.             "search" => "advance"
  133.         )
  134.     );
  135. $out2 = $g2->render("circumscriptii_arondate");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement