ساخت اپلیکیشن مدیریت موجودی انبار با PHP و MySQL — از صفر تا صد

1define('PHPGRID_DB_HOSTNAME', 'localhost'); //  host name
2define('PHPGRID_DB_USERNAME', 'root'); // database user name
3define('PHPGRID_DB_PASSWORD', ''); // database password
4define('PHPGRID_DB_NAME', 'InventoryManager'); // our donation manager database name
5define('PHPGRID_DB_TYPE', 'mysql'); // database type
6define('PHPGRID_DB_CHARSET','utf8'); // always 'utf8' in MySQL

1$dgProd = new C_DataGrid('SELECT * FROM products', 'id', 'products');
2$dgProd->set_col_hidden('id', false);
3$dgProd->enable_autowidth(true)->set_dimension('auto', '200px')->set_pagesize(100);
4
5$dgProd->set_col_title('ProductName', 'Name');
6$dgProd->set_col_title('PartNumber', 'Part Number');
7$dgProd->set_col_title('ProductLabel', 'Label');
8$dgProd->set_col_title('StartingInventory', 'Starting Inventory');
9$dgProd->set_col_title('InventoryReceived', 'Inventory Received');
10$dgProd->set_col_title('InventoryShipped', 'Inventory Shipped');
11$dgProd->set_col_title('InventoryOnHand', 'Inventory On Hand');
12$dgProd->set_col_title('MinimumRequired', 'Minimum Required');
13
14$dgProd->set_col_format('StartingInventory', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
15$dgProd->set_col_format('InventoryReceived', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
16$dgProd->set_col_format('InventoryShipped', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
17$dgProd->set_col_format('InventoryOnHand', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
18$dgProd->set_col_format('MinimumRequired', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
19$dgProd->enable_edit('FORM');

1$dgProd->set_conditional_format(
2    'InventoryOnHand', 'CELL', 
3        array("condition"=>"lt",
4          "value"=>"1",
5          "css"=> array("color"=>"red","background-color"=>"#DCDCDC")));

1$onGridLoadComplete = <<<ONGRIDLOADCOMPLETE
2function(status, rowid)
3{
4    var ids = jQuery("#products").jqGrid('getDataIDs');
5    for (var i = 0; i < ids.length; i++)
6    {
7        var rowId = ids[i];
8        var rowData = jQuery('#products').jqGrid ('getRowData', rowId);
9
10        var inventoryOnHand = $("#products").jqGrid("getCell", rowId, "InventoryOnHand");
11        var minimumRequired = $("#products").jqGrid("getCell", rowId, "MinimumRequired");
12
13        // compare two dates and set custom display in another field "status" 
14        console.log(inventoryOnHand + " | " + minimumRequired);
15        if(parseInt(inventoryOnHand) < parseInt(minimumRequired)){
16            
17            $("#products").jqGrid("setCell", rowId, "PartNumber", '', {'background-color':'gold'}); 
18                
19        }
20    }
21
22}
23ONGRIDLOADCOMPLETE;
24$dgProd->add_event("jqGridLoadComplete", $onGridLoadComplete);

1// Purchases detail grid
2$dgPur = new C_DataGrid('SELECT id, PurchaseDate, ProductId, NumberReceived, SupplierId FROM purchases', 'id', 'purchases');
3$dgPur->set_col_hidden('id', false)->set_caption('Incoming Purchases');
4$dgPur->set_col_edittype('ProductId', 'select', "select id, ProductLabel from products");
5$dgPur->set_col_edittype('SupplierId', 'select', "select id, supplier from suppliers");
6$dgPur->set_dimension('800px');

1// Orders detail grid
2$dgOrd = new C_DataGrid('SELECT id, OrderDate, ProductId, NumberShipped, First, Last FROM orders', 'id', 'orders');
3$dgOrd->set_sortname('OrderDate', 'DESC')->set_caption('Outgoing Orders');
4$dgOrd->set_col_hidden('id', false);
5$dgOrd->set_col_edittype('ProductId', 'select', "select id, ProductLabel from products");
6$dgOrd->set_dimension('800px');

1$dgProd->set_masterdetail($dgPur, 'ProductId', 'id');
2$dgProd->set_masterdetail($dgOrd, 'ProductId', 'id');

1$dgProd = new C_DataGrid('SELECT * FROM products', 'id', 'products');
2$dgProd->set_col_hidden('id', false);
3$dgProd->enable_autowidth(true)->set_dimension('auto', '200px')->set_pagesize(100);
4
5$dgProd->set_col_title('ProductName', 'Name');
6$dgProd->set_col_title('PartNumber', 'Part Number');
7$dgProd->set_col_title('ProductLabel', 'Label');
8$dgProd->set_col_title('StartingInventory', 'Starting Inventory');
9$dgProd->set_col_title('InventoryReceived', 'Inventory Received');
10$dgProd->set_col_title('InventoryShipped', 'Inventory Shipped');
11$dgProd->set_col_title('InventoryOnHand', 'Inventory On Hand');
12$dgProd->set_col_title('MinimumRequired', 'Minimum Required');
13
14$dgProd->set_col_format('StartingInventory', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
15$dgProd->set_col_format('InventoryReceived', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
16$dgProd->set_col_format('InventoryShipped', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
17$dgProd->set_col_format('InventoryOnHand', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
18$dgProd->set_col_format('MinimumRequired', 'integer', array('thousandsSeparator'=>',', 'defaultValue'=>'0'));
19
20$dgProd->set_conditional_format('InventoryOnHand', 'CELL', array("condition"=>"lt",
21                                                  "value"=>"1",
22                                                  "css"=> array("color"=>"red","background-color"=>"#DCDCDC")));
23                                                  
24$onGridLoadComplete = <<<ONGRIDLOADCOMPLETE
25function(status, rowid)
26{
27    var ids = jQuery("#products").jqGrid('getDataIDs');
28    for (var i = 0; i < ids.length; i++)
29    {
30        var rowId = ids[i];
31        var rowData = jQuery('#products').jqGrid ('getRowData', rowId);
32
33        var inventoryOnHand = $("#products").jqGrid("getCell", rowId, "InventoryOnHand");
34        var minimumRequired = $("#products").jqGrid("getCell", rowId, "MinimumRequired");
35
36        // compare two dates and set custom display in another field "status" 
37        console.log(inventoryOnHand + " | " + minimumRequired);
38        if(parseInt(inventoryOnHand) < parseInt(minimumRequired)){
39            
40            $("#products").jqGrid("setCell", rowId, "PartNumber", '', {'background-color':'gold'}); 
41                
42        }
43    }
44
45}
46ONGRIDLOADCOMPLETE;
47$dgProd->add_event("jqGridLoadComplete", $onGridLoadComplete);
48$dgProd->enable_edit('FORM');
49
50// Purchases detail grid
51$dgPur = new C_DataGrid('SELECT id, PurchaseDate, ProductId, NumberReceived, SupplierId FROM purchases', 'id', 'purchases');
52$dgPur->set_col_hidden('id', false)->set_caption('Incoming Purchases');
53$dgPur->set_col_edittype('ProductId', 'select', "select id, ProductLabel from products");
54$dgPur->set_col_edittype('SupplierId', 'select', "select id, supplier from suppliers");
55$dgPur->set_dimension('800px');
56
57// Orders detail grid
58$dgOrd = new C_DataGrid('SELECT id, OrderDate, ProductId, NumberShipped, First, Last FROM orders', 'id', 'orders');
59$dgOrd->set_sortname('OrderDate', 'DESC')->set_caption('Outgoing Orders');
60$dgOrd->set_col_hidden('id', false);
61$dgOrd->set_col_edittype('ProductId', 'select', "select id, ProductLabel from products");
62$dgOrd->set_dimension('800px');
63
64$dgProd->set_masterdetail($dgPur, 'ProductId', 'id');
65$dgProd->set_masterdetail($dgOrd, 'ProductId', 'id');
66$dgProd->display();

1$dgPur -> set_group_properties('ProductId', false, true, true, false);
2$dgPur -> set_group_summary('NumberReceived','sum');

1$dgPur = new C_DataGrid('SELECT id, PurchaseDate, ProductId, NumberReceived, SupplierId FROM purchases', 'id', 'purchases');
2$dgPur->set_col_hidden('id', false);
3
4$dgPur->set_col_title('PurchaseDate', 'Date of Purchase');
5$dgPur->set_col_title('ProductId', 'Product');
6$dgPur->set_col_title('NumberReceived', 'Number Received');
7$dgPur->set_col_title('SupplierId', 'Supplier');
8
9$dgPur->set_col_edittype('ProductId', 'select', "select id, ProductLabel from products");
10$dgPur->set_col_edittype('SupplierId', 'select', "select id, supplier from suppliers");
11
12// $dgPur->enable_edit('FORM');
13$dgPur->set_pagesize(100);
14
15$dgPur->set_col_width('PurchaseDate', '50px');
16$dgPur->set_col_width('NumberReceived', '35px');
17
18$dgPur -> set_group_properties('ProductId', false, true, true, false);
19$dgPur -> set_group_summary('NumberReceived','sum');
20
21$dgPur->enable_autowidth(true);
22$dgPur->display();

1$dgOrd = new C_DataGrid('SELECT id, OrderDate, ProductId, NumberShipped, First, Last FROM orders', 'id', 'orders');
2$dgOrd->set_sortname('OrderDate', 'DESC');
3$dgOrd->set_col_hidden('id', false);
4
5$dgOrd->set_col_title('OrderDate', 'Order Date');
6$dgOrd->set_col_title('ProductId', 'Product');
7$dgOrd->set_col_title('NumberShipped', 'Number Shipped');
8
9$dgOrd->set_col_edittype('ProductId', 'select', "select id, ProductLabel from products");
10
11// $dgOrd->enable_edit('FORM');
12$dgOrd->set_pagesize(100);
13
14$dgOrd->set_col_width('OrderDate', '30px');
15$dgOrd->set_col_width('NumberShipped', '35px');
16$dgOrd->set_col_width('First', '20px');
17$dgOrd->set_col_width('Last', '20px');
18
19$dgOrd->set_grid_method('setGroupHeaders', array(
20                                array('useColSpanStyle'=>true),
21                                'groupHeaders'=>array(
22                                        array('startColumnName'=>'First',
23                                              'numberOfColumns'=>2,
24                                              'titleText'=>'Customer Name') )));
25
26$dgOrd->enable_autowidth(true);
27$dgOrd->display();

1require_once("phpGrid/conf.php"); 
2require_once("phpChart/conf.php");

1$pc = new C_PhpChartX(array(array(null)), 'PieChart');
2$pc->set_title(array('text'=>'Current Inventory Summary'));
3$pc->set_series_default(array( 'shadow'=> false, 
4    'renderer'=> 'plugin::PieRenderer', 
5    'rendererOptions'=> array( 
6      'showDataLabels' => true,
7      'highlightMouseOver' => true,
8      'startAngle'=> 180, 
9      'sliceMargin'=> 4, 
10      'showDataLabels'=> true ) 
11  ));
12$pc->set_legend(array('show'=>true,'location'=> 'w'));
13// remove background
14$pc->set_grid(array(
15    'background'=>'white',
16    'borderWidth'=>0,
17    'borderColor'=>'#000000',
18    'shadow'=>false));
19$pc->add_custom_js("
20        $('#PieChart').bind('jqplotDataHighlight',
21            function (ev, seriesIndex, pointIndex, data) {
22               $('#label_info').text(data);      
23            }
24        );
25    ");
26$pc->draw(660,400);

1$pc = new C_PhpChartX(array(array(null)), 'PieChart');

1$pc->set_title(array('text'=>'Current Inventory Summary'));

1$pc->set_series_default(array( 'shadow'=> false, 
2    'renderer'=> 'plugin::PieRenderer', 
3    'rendererOptions'=> array(
4      'highlightMouseOver' => true,
5      'startAngle'=> 180,
6      'sliceMargin'=> 4,
7      'showDataLabels'=> true )
8  ));

1$pc->set_legend(array('show'=>true,'location'=> 'w'));

1$pc->set_grid(array(
2    'background'=>'white',
3    'borderWidth'=>0,
4    'borderColor'=>'#000000',
5    'shadow'=>false));

1$pc->draw(660,400);

1function(status, rowid)
2{
3	var dataX = [];
4	var dataY = [];
5
6	d1 = $('#products').jqGrid('getCol', 'ProductLabel', false);
7	d2 = $('#products').jqGrid('getCol', 'InventoryReceived', false);
8	
9	npoints = d1.length;
10	for(var i=0; i < npoints; i++){
11		dataX[i] = [i+1, d1[i]];
12		dataY[i] = [i+1, parseInt(d2[i])];
13	}
14
15    var pieData = [];
16    for(var j=0; j < dataX.length; j++)
17    {
18        pieData.push([dataX[j][1], dataY[j][1]]);
19    }
20    console.log(pieData);
21    _PieChart.series[0].data = pieData;
22    _PieChart.replot({resetAxes:true});
23}

1$dgProd = new C_DataGrid('SELECT id, ProductLabel, InventoryReceived FROM products', 'id', 'products');
2$dgProd->set_col_hidden('id', false);
3$dgProd->set_dimension('auto', 'auto')->set_pagesize(100);
4$onGridLoadComplete = <<<ONGRIDLOADCOMPLETE
5function(status, rowid)
6{
7	var dataX = [];
8	var dataY = [];
9
10	d1 = $('#products').jqGrid('getCol', 'ProductLabel', false);
11	d2 = $('#products').jqGrid('getCol', 'InventoryReceived', false);
12	d3 = $('#products').jqGrid('getCol', 'InventoryShipped', false);
13	d4 = $('#products').jqGrid('getCol', 'InventoryOnHand', false);
14
15	
16	npoints = d1.length;
17	for(var i=0; i < npoints; i++){
18		dataX[i] = [i+1, d1[i]];
19		dataY[i] = [i+1, parseInt(d2[i])];
20	}
21
22    var pieData = [];
23    for(var j=0; j < dataX.length; j++)
24    {
25        pieData.push([dataX[j][1], dataY[j][1]]);
26    }
27    console.log(pieData);
28    _PieChart.series[0].data = pieData;
29    _PieChart.replot({resetAxes:true});
30}
31ONGRIDLOADCOMPLETE;
32$dgProd->add_event("jqGridLoadComplete", $onGridLoadComplete);
33$dgProd->display();