Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $g = new jqgrid();
- $grid["caption"] = "Circumscripții";
- $grid["autowidth"] = true; // expand grid to screen width
- $grid["multiselect"] = false;
- $grid["height"] = "auto";
- $grid["detail_grid_id"] = "circumscriptii_arondate";
- $grid["subgridparams"] = "id,cod";
- $g->set_options($grid);
- $e["on_insert"] = array("circumscriptie_adauga", null, false);
- $e["on_update"] = array("circumscriptie_editeaza", null, false);
- $g->set_events($e);
- $g->table = "circumscriptii";
- $g->set_actions(array(
- "add"=>true,
- "edit"=>true,
- "delete"=>false,
- "clone"=>false,
- "rowactions"=>false,
- "search" => "advance",
- "showhidecolumns" => false
- )
- );
- $out = $g->render("circumscriptii");
- // [-] MASTER GRID
- // [+] DETAIL GRID
- $g2 = new jqgrid();
- $grid=array(); //clear $grid
- $grid["caption"] = "Arondare circumscripție";
- $grid["height"] = "";
- $grid["autowidth"] = true;
- $grid["add_options"]["beforeInitData"] = "function(formid){ var selr = jQuery('#circumscriptii').jqGrid('getGridParam','selrow'); if (!selr) { alert('Selectează întâi o circumscripție!'); return false; } }";
- $g2->set_options($grid);
- $_id = intval($_GET["rowid"]);
- $cod = $_GET["cod"];
- $cid = intval($_GET["id"]);
- /// SELECTION OF DETAIL GRIB BASED ON MASTER GRID
- $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
- FROM circumscriptii_arondate, circumscriptii, utilizatori_info
- WHERE circumscriptii_arondate.circumscriptie = circumscriptii.id
- AND circumscriptii_arondate.medic = utilizatori_info.utilizator
- AND circumscriptie={$cid}
- GROUP BY circumscriptii_arondate.id";
- $g2->table = "circumscriptii_arondate";
- $cols = array(); //clear $cols
- $col = array(); //clear $col
- $col["title"] = "Id";
- $col["name"] = "id";
- $col["editable"] = true;
- $col["editoptions"] = array(
- "readonly" => "readonly");
- $col["search"] = false;
- $cols[] = $col;
- $col = array();
- $col["title"] = "Circumscriptie";
- $col["name"] = "circumscriptie";
- $col["editable"] = false;
- $col["editoptions"] = array(
- "readonly" => "readonly");
- $col["default"] = $cod;
- $col["search"] = false;
- $cols[] = $col;
- $col = array();
- $col["title"] = "Cod circumscripție";
- $col["name"] = "circumscriptie_cod";
- $col["editable"] = false;
- $col["hidden"] = true;
- $col["search"] = false;
- $cols[] = $col;
- $col = array(); // HIDE FROM LIST BUT SHOW ON EDIT
- $col["title"] = "Medic";
- $col["name"] = "medic";
- $col["hidden"] = true;
- $col["editable"] = true;
- $col["edittype"] = "select";
- // PROBLEMS IN DROPDOWN
- $str = $g2->get_dropdown_values("SELECT utilizator as k, CONCAT(nume,' ', prenume) as v FROM utilizatori_info
- WHERE utilizator NOT IN (SELECT id FROM utilizatori WHERE stare<>1)
- AND utilizator NOT IN (SELECT medic FROM circumscriptii_arondate WHERE circumscriptie=".$cid.")");
- $col["editoptions"] = array("value"=>$str);
- $col["editrules"] = array("edithidden"=>true);
- $cols[] = $col;
- $col = array();
- $col["title"] = "Medic arondat";
- $col["name"] = "nume";
- $col["editable"] = false;
- $col["default"] = "<a href=\"#link_catre_medic\">{nume} {prenume}</a>";
- $cols[] = $col;
- $col = array(); //this with the above "nume" will be solve with SQL CONCAT
- $col["name"] = "prenume";
- $col["editable"] = false;
- $col["hidden"] = true;
- $cols[] = $col;
- $col = array();
- $col["title"] = "Data arondare";
- $col["name"] = "data_arondare";
- $col["align"] = "center";
- $col["formatter"] = "date";
- $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d.m.Y');
- $col["editable"] = false;
- $col["search"] = false;
- $cols[] = $col;
- $g2->set_columns($cols);
- $e["on_insert"] = array("add_client", null, true);
- $e["on_update"] = array("edit_client", null, false);
- $g2->set_events($e);
- $g2->set_actions(array(
- "add"=>true,
- "edit"=>true,
- "delete"=>false,
- "rowactions"=>false,
- "autofilter" => true,
- "search" => "advance"
- )
- );
- $out2 = $g2->render("circumscriptii_arondate");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement