L0794
LF012

PHP php 5.6 compatibale 
Singale File,Light blue very light blu background,Buteyfull GUI, Better alinged GUI

screen save mode.shortcut keys, enter key as tab index
1.php Singale File.
2.size 12 font (dark)
3.Use full screen 

4.Top New,Post,Print,Find,Exit Ovel Shape Buttons
short cut keys
New-Ctrl+N,Post-Ctrl+S,Print-Ctrl+P,Find-Ctrl+F,Exit-Ctrl+E
Tab, Enter Button As Tab

Devide screen 2 parts in vertical 
Button actions
A.New Button

left hand Side
Header details
get refno from invpara
Refno=select ord_no as Refno from invpara
with leading zero 5 and prefix "ORD-"
Sdate =current date,short date,input
S_date=current date,short date,input
lc_no= ''

barnd_name combo box
sql=SELECT  barnd_name as brand from brand_mas order by barnd_name

DEP_CODE combo box 
sql=SELECT  CODE as DEP_CODE,DESCRIPTION as DEP_NAME from s_stomas order by DEP_CODE

REP_CODE combo box
sql=select REPCODE as REP_CODE,Name as REP_NAME from s_salrep order by REP_CODE

Red colour "*" infront of combo boxes

Line Details
grid_s_ord_trn light grid line
stk_no,Descript,partno,ORD_QTY


Find button next to stk_no
load ajex scren with Grid and keypress,onkey press seek, softseek
sql=select STK_NO,descript,part_no as partno,gen_no as Gen_no,qtyinhand from s_mas where  STK_NO or descript or part_no like=? limit to 20
select a item from Grid with Select  Button
Record select by select button or enter keypress

load STK_NO,descript,part_no to grid_s_ord_trn
disply qtyinhand
let enter Qty
add record to grid_s_ord_trn for line details

//.........................................................................................................................................
Display last 6 months purchases and sales, Month wise 
purchases
sql=select sum(tru_qty) as purchase from s_trn where (ledindi='ARN' or  ledindi='ARR')  and  stk_no=? group by sdate 
sales
sql=select sum(tru_qty) as sales from s_trn  where (ledindi='INV' or ledindi='GRN') and stk_no=? group by sdate 

Exsample:
May-2026       Apr-2026      Mar-2026        Feb-2026       Jan-2026       Dec-2026 		
purchases Sales  purchases Sales  purchases Sales  purchases Sales  purchases Sales  purchases Sales 
Display figures even zero values,purchases Sales values in diffrent colours

small Line chart for purchases Sales  in month wise,Grid line in chart

Display Blue_Card Grid Colour is Blue colour bottom of the left side
sql= SELECT REFNO,SDATE,STK_NO,DESCRIPT,ORD_QTY-rec_qty  from s_ordtrn where stk_no=? and  cancel='0' ORDER BY id desc 

//..........................................................................................................................................................
Right hand side Display Stock_tht_gen_no  with light grid line
tick mark for "ignore no stock"
if tick 
   sql="select STK_NO,descript,qtyinhand from s_mas where qtyinhand > 0 and gen_no like =? limit to 50"
else
   sql="select STK_NO,descript,qtyinhand from s_mas where gen_no like =? limit to 50"
endif
When focus grid_tht_gen_no row display last six month sales and purchases related to stk_no on grid_tht_gen



purchases
sql=select sum(tru_qty) as purchases from s_trn where (ledindi='ARN' or  ledindi='ARR')  and  stk_no=? group by sdate 
sales
sql=select sum(tru_qty) as sales from s_trn  where (ledindi='INV' or ledindi='GRN') and stk_no=? group by sdate 
purchases Sales values in diffrent colours

When focus grid_tht_gen_no row display 
Display Blue_Card_tht  orange  stk_no relevent to  grid_tht_gen_no
sql= SELECT REFNO,SDATE,STK_NO,DESCRIPT,ORD_QTY-rec_qty from s_ordtrn where stk_no=?  and cancel=0 ORDER BY id desc 


$host = 'localhost';
$user = 'root';
$password = '';
$database = 'swijesooriya_tht';

//..........................................................................................................................................................
autofill
Right hand side in grid_ben_gen_no with light grid line
if tick 
   sql="select STK_NO,descript,qtyinhand from s_mas where qtyinhand > 0 and gen_no like =? limit to 50"
else
   sql="select STK_NO,descript,qtyinhand from s_mas where gen_no like =? limit to 50"
endif

When focus grid_ben_gen_no row display last six month sales and purchases related to stk_no grid_ben_gen

purchases
sql=select sum(tru_qty) as purchases from s_trn where (ledindi='ARN' or  ledindi='ARR')  and  stk_no=? group by sdate 
sales
sql=select sum(tru_qty) as sales from s_trn  where (ledindi='INV' or ledindi='GRN') and stk_no=? group by sdate 
purchases Sales values in diffrent colours

When focus grid_ben_gen_no row display 
Display Blue_Card_ben Grid, Colour  pink stk_no relevent to  grid_ben_gen_no
sql= SELECT REFNO,SDATE,STK_NO,DESCRIPT,ORD_QTY from s_ordtrn where stk_no=? and rec_qty < ord_qty  and active='1' ORDER BY id desc 


$host = 'localhost';
$user = 'root';
$password = '';
$database = 'swijesooriya_ben';


[Post] Button Action
update invpara
sql=update invpara set ord_no=ord_no+1


header details
insertinto s_ordmas(
REFNO
SDATE
SUP_CODE
SUP_NAME
DEP_CODE
DEP_NAME
REP_CODE
REP_NAME
S_date
LC_No
Brand

line details (grid_s_ord_trn)
insertinto s_ordtrn
REFNO
SDATE
STK_NO
DESCRIPT
ORD_QTY
partno

Call [Printer] Buttion press

[Printer] 

Header details
Company Name
Purchse Order 

select REFNO,
SDATE,
SUP_CODE,
SUP_NAME,
DEP_CODE,
DEP_NAME,
REP_CODE,
REP_NAME,
S_date,
LC_No,
Brand
from insertinto s_ordmas where id=?

line details
select 
REFNO,
SDATE,
STK_NO,
DESCRIPT,
ORD_QTY

from 
s_ordtrn where refno=?


Enterrd By
Authorized By

printed date
Printed time