gistfile1.txt

<?php

include_once("config.php");

// include and create object
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

$db_conf = array(   
                    "type"      => PHPGRID_DBTYPE, 
                    "server"    => PHPGRID_DBHOST,
                    "user"      => PHPGRID_DBUSER,
                    "password"  => PHPGRID_DBPASS,
                    "database"  => PHPGRID_DBNAME
                );
				
$g = new jqgrid($db_conf);
// set database table for CRUD operations
$g->table = "sales_flat_order_phpcrud";

$g->select_command = "
SELECT *
FROM sales_flat_order_phpcrud
";

$opt_ord["caption"] = "Ordini";
$opt_ord["sortname"] = 'increment_id'; 
$opt_ord["sortorder"] = "DESC";
$opt_ord["height"] = "600";
$opt_ord["rowNum"] = 200;
$opt_ord["forceFit"] = true;
$opt_ord["autoresize"] = false;
$opt_ord["add_options"] = array('width'=>'420');
$opt_ord["edit_options"] = array('width'=>'420');
$opt_ord["view_options"] = array('width'=>'420');
$opt_ord["toolbar"] = "top";

$opt_ord["subGrid"] = true;
$opt_ord["subgridurl"] = "ordini_righe.php";
$opt_ord["subgridparams"] = "entity_id"; // no spaces b/w column names

$g->set_actions(array(	
		"add"=>false, // allow/disallow add
		"edit"=>false, // allow/disallow edit
		"delete"=>false, // allow/disallow delete
		"bulkedit"=>false, // allow/disallow delete
		"showhidecolumns"=>true, // allow/disallow delete
		"rowactions"=>false, // show/hide row wise edit/del/save option
		"autofilter" => true, // show/hide autofilter for search
		"export" => false,
		"import" => false,
		"search" => "advance"
		
		
	) 
);

$col = array();
$col["title"] = "Entity id"; // caption of column, can use HTML tags too
$col["name"] = "entity_id"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
$col["editable"] = false;
$col["hidden"] = true;
$cols_ord[] = $col;

$col = array();
$col["title"] = "Ordine #"; // caption of column, can use HTML tags too
$col["name"] = "increment_id"; // grid column name, same as db field or alias from sql
$col["link"] = "http://computer.milano.it/index.php/admin/sales_order/view/order_id/{entity_id}";
$col["linkoptions"] = "target='_magento_ordine'"; // extra params with <a> tag
$col["default"] = "{increment_id}"; // default link text
$col["width"] = "20"; // width on grid
$col["editable"] = false;
$col["searchoptions"]["sopt"] = array("eq");
$cols_ord[] = $col;

$col = array();
$col["title"] = "Ricevuto il"; // caption of column, can use HTML tags too
$col["name"] = "created_at"; // grid column name, same as db field or alias from sql
$col["width"] = "20"; // width on grid
//$col["formatter"] = "date";
$cols_ord[] = $col;

$col = array();
$col["title"] = "Fatturato il"; // caption of column, can use HTML tags too
$col["name"] = "data_fattura"; // grid column name, same as db field or alias from sql
$col["width"] = "20"; // width on grid
// $col["formatter"] = "date";
// $col["formatoptions"] = array("srcformat"=>'Y-m-d',"newformat"=>'d/m/Y');
$cols_ord[] = $col;

$col = array();
$col["title"] = "Gestito il"; // caption of column, can use HTML tags too
$col["name"] = "data_ordine_fornitore"; // grid column name, same as db field or alias from sql
$col["width"] = "20"; // width on grid
// $col["formatter"] = "date";
$cols_ord[] = $col;

$col = array();
$col["title"] = "Spedito il"; // caption of column, can use HTML tags too
$col["name"] = "data_spedizione"; // grid column name, same as db field or alias from sql
$col["width"] = "20"; // width on grid
// $col["formatter"] = "date";
$cols_ord[] = $col;

// $col = array();
// $col["title"] = "Stato"; // caption of column, can use HTML tags too
// $col["name"] = "state"; // grid column name, same as db field or alias from sql
// $col["width"] = "30"; // width on grid
// $col["editable"] = false;
// $cols_ord[] = $col;

$col = array();
$col["title"] = "Totale €"; // caption of column, can use HTML tags too
$col["name"] = "base_grand_total"; // grid column name, same as db field or alias from sql
$col["width"] = "30"; // width on grid
$col["editable"] = false;
$col["formatter"] = "number";
$col["formatoptions"] = array("thousandsSeparator" => "","decimalSeparator" => ",","decimalPlaces" => 2);
$cols_ord[] = $col;

$col = array();
$col["title"] = "Pagamento"; // caption of column, can use HTML tags too
$col["name"] = "method"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
//$col["condition"] = array('$row["asasas"] = "complete"', 'Autorizzato', 'n.d.');
//$col["condition"] = array('$row["method"] = "paypal_standard"', 'Paypal', 'n.d.');
$col["edittype"] = “select”; // render as select
$str = $g->get_dropdown_values("SELECT codice_negozio AS k, descrizione AS v FROM tipidipagamentonegozio");
$col["editoptions"] = array("value"=>$str);
$col["formatter"] = "select"; // display label, not value
$col["editable"] = false;
$cols_ord[] = $col;

$col = array();
$col["title"] = "Consegna"; // caption of column, can use HTML tags too
$col["name"] = "shipping_description"; // grid column name, same as db field or alias from sql
$col["edittype"] = “select”; // render as select
$str = $g->get_dropdown_values("SELECT codice_negozio AS k, descrizione AS v FROM tipidiconsegnanegozio");
$col["editoptions"] = array("value"=>$str);
$col["formatter"] = "select"; // display label, not value
$col["width"] = "30"; // width on grid
$col["editable"] = false;
$cols_ord[] = $col;

// $col = array();
// $col["title"] = "Spedizione"; // caption of column, can use HTML tags too
// $col["name"] = "shipping_method"; // grid column name, same as db field or alias from sql
// $col["width"] = "30"; // width on grid
// $col["editable"] = false;
// $cols_ord[] = $col;

$col = array();
$col["title"] = "Azienda"; // caption of column, can use HTML tags too
$col["name"] = "company"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
$col["editable"] = false;
$cols_ord[] = $col;

$col = array();
$col["title"] = "Nome"; // caption of column, can use HTML tags too
$col["name"] = "firstname"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
$col["editable"] = false;
$cols_ord[] = $col;

$col = array();
$col["title"] = "Cognome"; // caption of column, can use HTML tags too
$col["name"] = "lastname"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
$col["editable"] = false;
$cols_ord[] = $col;

$col = array();
$col["title"] = "Telefono"; // caption of column, can use HTML tags too
$col["name"] = "telephone"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
$col["editable"] = false;
$cols_ord[] = $col;

$col = array();
$col["title"] = "Email"; // caption of column, can use HTML tags too
$col["name"] = "customer_email"; // grid column name, same as db field or alias from sql
$col["width"] = "40"; // width on grid
$col["editable"] = false;
$cols_ord[] = $col;

// $col = array();
// $col["title"] = "Satus"; // caption of column, can use HTML tags too
// $col["name"] = "status"; // grid column name, same as db field or alias from sql
// $col["width"] = "40"; // width on grid
// $col["editable"] = false;
// $cols_ord[] = $col;



$f = array();
$f["column"] = "created_at";
$f["op"] = "cn";
$f["value"] = "2021";
$f["css"] = "'background-color':'#FF6262'";//rosso di default
$f_conditions[] = $f;

$f = array();
$f["column"] = "data_fattura";
$f["op"] = "cn";
$f["value"] = "2021";
$f["css"] = "'background-color':'#FFC862'";//arancione se è stato fatturato
$f_conditions[] = $f;

$f = array();
$f["column"] = "method";
$f["op"] = "=";
$f["value"] = "m2epropayment";
$f["css"] = "'background-color':'#FFC862'";//arancione se proviene da amzon/ebay
$f_conditions[] = $f;

$f = array();
$f["column"] = "method";
$f["op"] = "=";
$f["value"] = "cashondelivery";
$f["css"] = "'background-color':'#FFC862'";//arancione se è un contrassegno
$f_conditions[] = $f;

$f = array();
$f["column"] = "method";
$f["op"] = "=";
$f["value"] = "checkmo";
$f["css"] = "'background-color':'#FFC862'";//arancione se è un contrassegno
$f_conditions[] = $f;


$f = array();
$f["column"] = "state";
$f["op"] = "=";
$f["value"] = "canceled";
$f["css"] = "'background-color':'#CACDD0'";//grigio se è annullato
$f_conditions[] = $f;

$f = array();
$f["column"] = "state";
$f["op"] = "=";
$f["value"] = "complete";
$f["css"] = "'background-color':'#00B359'";//verde se è completo
$f_conditions[] = $f;



$g->set_options($opt_ord);
//$g->select_command = "SELECT * FROM fornitori WHERE attivato = 'SI'";
$g->set_conditional_css($f_conditions);
//pass the cooked columns to grid
$g->set_columns($cols_ord);
// render grid and get html/js output
$out_ord = $g->render("list1");


// DA GESTIRE *****************************************************************************************************************************************************

$g = new jqgrid($db_conf);
// set database table for CRUD operations
$g->table = "sales_flat_order_item";

$g->select_command = "
SELECT *
FROM sales_flat_order_item_phpcrud
" ;

//SELECT sales_flat_order_item.item_id, sales_flat_order_item_gest.item_id
//FROM sales_flat_order_item LEFT JOIN sales_flat_order_item_gest ON sales_flat_order_item.item_id = sales_flat_order_item_gest.item_id
//WHERE (((sales_flat_order_item_gest.item_id) Is Null));



$g->set_actions(array(	
		"add"=>false, // allow/disallow add
		"edit"=>false, // allow/disallow edit
		"delete"=>false, // allow/disallow delete
		"bulkedit"=>false, // allow/disallow delete
		"showhidecolumns"=>false, // allow/disallow delete
		"rowactions"=>false, // show/hide row wise edit/del/save option
		"autofilter" => true, // show/hide autofilter for search
		"export" => false,
		"import" => false,
		"view" => true,
		"search" => true,
		"refresh"=> true,

	) 
);

$opt_items_gest["caption"] = "Righe";
$opt_items_gest["sortname"] = 'item_id'; 
$opt_items_gest["sortorder"] = "DESC";
$opt_items_gest["height"] = "600";
$opt_items_gest["rowNum"] = 50;
$opt_items_gest["forceFit"] = true;
$opt_items_gest["autoresize"] = true;
$opt_items_gest["toolbar"] = "top";
$opt_items_gest["hidegrid"] = true;
$opt_items_gest["rowList"] = array();
$opt_items_gest["pgbuttons"] = true;
$opt_items_gest["pgtext"] = null;
$opt_items_gest["viewrecords"] = true;

$opt_items_gest["grouping"] = true;
$opt_items_gest["groupingView"] = array();

// specify column name to group listing
$opt_items_gest["groupingView"]["groupField"] = array("increment_id_and_more");
// show group in asc or desc order
$opt_items_gest["groupingView"]["groupOrder"] = array("desc");
// either show grouped column in list or not (default: true)
$opt_items_gest["groupingView"]["groupColumnShow"] = array(false);

//$g->select_command = "SELECT * FROM sales_flat_order_item_gest WHERE fornitore_effettivo = 'Outlet' or destinazione = 'Outlet'";

// $col = array();
// $col["title"] = "ID"; // caption of column, can use HTML tags too
// $col["name"] = "id_megalistino"; // grid column name, same as db field or alias from sql
// $col["width"] = ""; // width on grid
// $col["editable"] = false;
// $cols[] = $col;

$col = array();
$col["title"] = "Ordine #"; // caption of column, can use HTML tags too
$col["name"] = "increment_id"; // grid column name, same as db field or alias from sql
$col["width"] = "25"; // width on grid
$col["editable"] = false;
//$col["sortable"] = false;
//$col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Ordine and more"; // caption of column, can use HTML tags too
$col["name"] = "increment_id_and_more"; // grid column name, same as db field or alias from sql
$col["width"] = "25"; // width on grid
$col["editable"] = false;
//$col["sortable"] = false;
$col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Data"; // caption of column, can use HTML tags too
$col["name"] = "created_at"; // grid column name, same as db field or alias from sql
$col["width"] = "25"; // width on grid
$col["editable"] = false;
//$col["sortable"] = false;
//$col["hidden"] = true;
$cols_items_gest[] = $col;


$col = array();
$col["title"] = "Fatturato il"; // caption of column, can use HTML tags too
$col["name"] = "data_fattura"; // grid column name, same as db field or alias from sql
$col["width"] = "25"; // width on grid
$col["editable"] = false;
//$col["sortable"] = false;
$col["hidden"] = true;
$cols_items_gest[] = $col;


$col = array();
$col["title"] = "Pagamento"; // caption of column, can use HTML tags too
$col["name"] = "method"; // grid column name, same as db field or alias from sql
$col["width"] = "30"; // width on grid
//$col["condition"] = array('$row["asasas"] = "complete"', 'Autorizzato', 'n.d.');
//$col["condition"] = array('$row["method"] = "paypal_standard"', 'Paypal', 'n.d.');
$col["edittype"] = “select”; // render as select
$str = $g->get_dropdown_values("SELECT codice_negozio AS k, descrizione AS v FROM tipidipagamentonegozio");
$col["editoptions"] = array("value"=>$str);
$col["formatter"] = "select"; // display label, not value
$col["editable"] = false;
$col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Item id"; // caption of column, can use HTML tags too
$col["name"] = "item_id"; // grid column name, same as db field or alias from sql
$col["width"] = "25"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Codice rapido"; // caption of column, can use HTML tags too
$col["name"] = "product_id"; // grid column name, same as db field or alias from sql
$col["width"] = "20"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$col["hidden"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Fornitore consigliato"; // caption of column, can use HTML tags too
$col["name"] = "fornitore"; // grid column name, same as db field or alias from sql
$col["width"] = "10"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Sku"; // caption of column, can use HTML tags too
$col["name"] = "sku"; // grid column name, same as db field or alias from sql
$col["width"] = "25"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Marca"; // caption of column, can use HTML tags too
$col["name"] = "marca"; // grid column name, same as db field or alias from sql
$col["width"] = "50"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Nome"; // caption of column, can use HTML tags too
$col["name"] = "name"; // grid column name, same as db field or alias from sql
$col["editoptions"] = array("size"=>20);
$col["width"] = "50"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
// $col["hidden"] = true;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Qty"; // caption of column, can use HTML tags too
$col["name"] = "qty_ordered"; // grid column name, same as db field or alias from sql
$col["width"] = "10"; // width on grid
$col["formatoptions"] = array("thousandsSeparator" => "",
                                "decimalSeparator" => "",
                                "decimalPlaces" => 0);
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "B.o."; // caption of column, can use HTML tags too
$col["name"] = "qty_backordered"; // grid column name, same as db field or alias from sql
$col["width"] = "10"; // width on grid
$col["formatoptions"] = array("thousandsSeparator" => "",
                                "decimalSeparator" => "",
                                "decimalPlaces" => 0);
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Prezzo"; // caption of column, can use HTML tags too
$col["name"] = "base_price"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["formatter"] = "number";
$col["formatoptions"] = array("thousandsSeparator" => ".",
                                "decimalSeparator" => ",",
                                "decimalPlaces" => 2);
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Costo"; // caption of column, can use HTML tags too
$col["name"] = "base_cost"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["formatter"] = "number";
$col["formatoptions"] = array("thousandsSeparator" => ".",
                                "decimalSeparator" => ",",
                                "decimalPlaces" => 2);
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Brevi"; // caption of column, can use HTML tags too
$col["name"] = "Brevi"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Cesano"; // caption of column, can use HTML tags too
$col["name"] = "Cesano"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Cometa"; // caption of column, can use HTML tags too
$col["name"] = "Cometa"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Computergross"; // caption of column, can use HTML tags too
$col["name"] = "Computergross"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Dacom"; // caption of column, can use HTML tags too
$col["name"] = "Dacom"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Datamatic"; // caption of column, can use HTML tags too
$col["name"] = "Datamatic"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Eet"; // caption of column, can use HTML tags too
$col["name"] = "Eet"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Esprinet"; // caption of column, can use HTML tags too
$col["name"] = "Esprinet"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Esprivillage"; // caption of column, can use HTML tags too
$col["name"] = "Esprivillage"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Focelda"; // caption of column, can use HTML tags too
$col["name"] = "Focelda"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Ingrammicro"; // caption of column, can use HTML tags too
$col["name"] = "Ingrammicro"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Intracom"; // caption of column, can use HTML tags too
$col["name"] = "Intracom"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Jarltech"; // caption of column, can use HTML tags too
$col["name"] = "Jarltech"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Outlet"; // caption of column, can use HTML tags too
$col["name"] = "Outlet"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Runner"; // caption of column, can use HTML tags too
$col["name"] = "Runner"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Techdata"; // caption of column, can use HTML tags too
$col["name"] = "Techdata"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Trezzano"; // caption of column, can use HTML tags too
$col["name"] = "Trezzano"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$col = array();
$col["title"] = "Triangolo"; // caption of column, can use HTML tags too
$col["name"] = "Triangolo"; // grid column name, same as db field or alias from sql
$col["width"] = "15"; // width on grid
$col["editable"] = false;
$col["sortable"] = false;
$cols_items_gest[] = $col;

$f = array();
$f["column"] = "created_at";
$f["op"] = "cn";
$f["value"] = "2021";
$f["css"] = "'background-color':'#FF6262'";//rosso di default
$f_conditions_gest[] = $f;


$f = array();
$f["column"] = "data_fattura";
$f["op"] = "cn";
$f["value"] = "2021";
$f["css"] = "'background-color':'#FFC862'";//arancione se è stato fatturato
$f_conditions_gest[] = $f;


$f = array();
$f["column"] = "method";
$f["op"] = "=";
$f["value"] = "m2epropayment";
$f["css"] = "'background-color':'#FFC862'";//arancione se proviene da amzon/ebay
$f_conditions_gest[] = $f;

$f = array();
$f["column"] = "method";
$f["op"] = "=";
$f["value"] = "cashondelivery";
$f["css"] = "'background-color':'#FFC862'";//arancione se è un contrassegno
$f_conditions_gest[] = $f;

$f = array();
$f["column"] = "method";
$f["op"] = "=";
$f["value"] = "checkmo";
$f["css"] = "'background-color':'#FFC862'";//arancione se è un contrassegno
$f_conditions_gest[] = $f;



$opt_items_gest["subGrid"] = true;
$opt_items_gest["subgridurl"] = "ordini_righe_gest.php";
$opt_items_gest["subgridparams"] = "item_id, qty_ordered, marca, increment_id, name, sku, fornitore"; // no spaces b/w column names

$g->set_options($opt_items_gest);


$g->set_conditional_css($f_conditions_gest);
// pass the cooked columns to grid
$g->set_columns($cols_items_gest);

// render grid and get html/js output
$out_gest = $g->render("list2");

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>

    <!-- these css and js files are required by php grid -->
    <link rel="stylesheet" href="lib/js/themes/redmond/jquery-ui.custom.css"></link>  
    <link rel="stylesheet" href="lib/js/jqgrid/css/ui.jqgrid.css"></link> 
    <script src="lib/js/jquery.min.js" type="text/javascript"></script>
    <script src="lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
    <script src="lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>  
    <script src="lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
    <!-- these css and js files are required by php grid -->
	<style>
	.ui-jqgrid tr.jqgrow td
	{
		vertical-align: top;
		white-space: normal !important;
		padding:2px 5px;
	}
	.ui-jqdialog-content .CaptionTD
	{
		vertical-align: top !important;
	}

	.ui-jqdialog-content .form-view-data
	{
		white-space: normal !important;
	}
	</style>
</head>
<body>
<div id="tabs">
<ul>
<li><a href="#tabs-1">Ordini</a></li>
<li><a href="#tabs-2">Da gestire</a></li>
<li><a href="#tabs-3">Da spedire</a></li>
<li><a href="#tabs-4">Da tracciare</a></li>
<li><a href="#tabs-5">In ritardo</a></li>
</ul>
<div id="tabs-1">
	<p></p>
	<?php echo $out_ord ?>
</div>
<div id="tabs-2">
	<p></p>
	<?php echo $out_gest ?>
</div>
<div id="tabs-3">
	<p></p>
	<?php echo $out3 ?>
</div>

</div>


<script>
$(function() {
	$( "#tabs" ).tabs();
});
</script>

	</div>
</body>
</html>