/*******************************************************************
Program Name - xxinvpri.p
Purpose - Program to Print Invoice
Developed By - Shilpa K   <ITTI>
DATE - 06/12/2016
***********************************************************************/

{mfdeclre.i}
{pdf_inc.i}
DEFINE VARIABLE lc_inv_nbr LIKE so_mstr.so_inv_nbr NO-UNDO.
DEFINE VARIABLE lc_fname AS character format "x(30)" no-undo.
DEFINE VARIABLE li_text AS INTEGER NO-UNDO.
DEFINE VARIABLE li_count AS INTEGER NO-UNDO.
DEFINE VARIABLE li_totalqty LIKE idh_qty_inv.
DEFINE VARIABLE li_amount LIKE idh_qty_inv.

FORM
lc_inv_nbr AT 20 VALIDATE(lc_inv_nbr <> "" AND
CAN-FIND(FIRST ih_hist WHERE ih_inv_nbr = lc_inv_nbr),
IF lc_inv_nbr <> "" THEN
"ERROR: Invoice Number Doesnot Exist.  PleASe re-enter."
ELSE
"ERROR: Blank not allowed.  PleASe re-enter.")
WITH FRAME fr_a WIDTH 80 SIDE-LABELS.

REPEAT:
  ASSIGN lc_inv_nbr = ""
  li_text = 0
  li_count = 0
  li_totalqty = 0
  li_amount = 0
  li_text = 480.
  
  UPDATE lc_inv_nbr WITH FRAME fr_a.
  
  lc_fname = "Invoice@" + REPLACE(STRING(today),"/","") + REPLACE(STRING(time,"HH:MM:SS"),":","") + ".pdf".
  
  /* PDF File name *************************************************************/
  RUN pdf_new("spdf",lc_fname).
  RUN pdf_set_PaperType("spdf","A4").
  RUN pdf_new_page2("spdf","Portrait").
  
  
  /* Loading Barcode ***********************************************************/
  RUN pdf_load_font("spdf","Code39","/mfgtmp/aovhaln/Code39.ttf","/mfgtmp/aovhaln/Code39.afm","").
  
  
  /* Header Box ****************************************************************/
  RUN pdf_stroke_fill("Spdf",1.0,1.0,1.0).
  RUN pdf_rect("spdf",25,30,545,770,0.75).      /* RECTANGLE BOX */
  
  /* Loading AND Placing Image 1 ***********************************************/
  RUN pdf_load_image("spdf","DelphiLogo","ADI2.jpg").
  RUN pdf_place_image("spdf","DelphiLogo",35,88,60,45).
  
  
  /* HEADER Text ***************************************************************/
  RUN pdf_set_font("Spdf","Helvetica-Bold",20).
  RUN pdf_text_xy("Spdf","INVOICE",250,770).
  
  /* Horizontal Lines **********************************************************/
  RUN pdf_line("spdf",25,760,570,760,0.75).     /* 1st full horizontal line */
  RUN  pdf_line("spdf",25,670,570,670,0.75).
  RUN  pdf_line("spdf",25,580,570,580,0.75).
  RUN pdf_line("spdf",25,520,570,520,0.75).
  RUN pdf_line("spdf",25,490,570,490,0.75).
  RUN  pdf_line("spdf",25,340,570,340,0.75).
  RUN  pdf_line("spdf",25,310,570,310,0.75).
  
  /* Vertical Lines ***********************************************************/
  RUN pdf_line("spdf",200,580,200,670,0.75).
  RUN pdf_line("spdf",380,580,380,670,0.75).
  RUN pdf_line("spdf",270,520,270,580,0.75).
  RUN pdf_line("spdf",380,520,380,580,0.75).
  RUN pdf_line("spdf",50,340,50,520,0.75).
  RUN pdf_line("spdf",200,340,200,520,0.75).
  RUN pdf_line("spdf",300,310,300,520,0.75).
  RUN pdf_line("spdf",380,310,380,520,0.75).
  RUN pdf_line("spdf",410,310,410,520,0.75).
  RUN pdf_line("spdf",480,310,480,520,0.75).
  
  /* Header Line text */
  RUN pdf_set_font("Spdf","Helvetica-bold",10).
  RUN pdf_text_xy("Spdf","Bill To:",33,655).
  RUN pdf_text_xy("Spdf","Ship To:",210,655).
  RUN pdf_text_xy("Spdf","Invoice No/ Date:",385,655).
  RUN pdf_text_xy("Spdf","Total",270,320).
  
  RUN pdf_set_font("Spdf","Helvetica",10).
  RUN pdf_text_xy("Spdf","Buyers's PO No/ Date:",385,635).
  
  RUN pdf_text_xy("Spdf","Despatched Through",33,570).
  RUN pdf_text_xy("Spdf","Date & Time of Invoice",273,570).
  RUN pdf_text_xy("Spdf","Authenticated By",430,570).
  RUN pdf_text_xy("Spdf","FOR Adient Pvt.Ltd",430,555).
  RUN pdf_text_xy("Spdf","Authorised Signatory",430,525).
  RUN pdf_text_xy("Spdf","SL",33,510).
  RUN pdf_text_xy("Spdf","Description of Goods",65,510).
  RUN pdf_text_xy("Spdf","Part No",230,510).
  RUN pdf_text_xy("Spdf","Quantity",320,510).
  RUN pdf_text_xy("Spdf","UOM",385,510).
  RUN pdf_text_xy("Spdf","Unit Rate",420,510).
  RUN pdf_text_xy("Spdf","Total Amount",490,510).
  RUN pdf_text_xy("Spdf","No",33,500).
  
  
  FOR FIRST ih_hist NO-LOCK WHERE ih_inv_nbr = lc_inv_nbr,
    EACH idh_hist NO-LOCK WHERE idh_inv_nbr = ih_inv_nbr BREAK BY idh_inv_nbr:
    
    IF FIRST-OF(idh_inv_nbr) THEN
    DO:
        RUN pdf_set_font("Spdf","Helvetica",10).
        RUN pdf_text_xy("Spdf",ih_inv_nbr,470,655).
        RUN pdf_text_xy("Spdf",ih_inv_date,530,655).
        RUN pdf_text_xy("Spdf",ih_po,510,635).
        RUN pdf_text_xy("Spdf",ih_shipvia,33,550).
        
        RUN pdf_set_font("Spdf","Helvetica",15).
        RUN pdf_text_xy("Spdf",ih_inv_nbr,250,130).
        
      FIND FIRST tr_hist NO-LOCK WHERE tr_type = "ISS-SO"
      AND tr_nbr = ih_nbr
      AND tr_rmks = ih_inv_nbr NO-ERROR.
      IF AVAILABLE tr_hist THEN 
      DO:
        RUN pdf_set_font("Spdf","Helvetica",10).
        RUN pdf_text_xy("Spdf",tr_effdate,273,550).
        RUN pdf_text_xy("Spdf",STRING(tr_time,"HH:MM:SS"),320,550).
        
        FIND FIRST si_mstr WHERE si_site = ih_site NO-LOCK NO-ERROR.
        IF AVAILABLE si_mstr THEN
        DO:
          FIND FIRST ad_mstr WHERE ad_addr = ih_site NO-LOCK NO-ERROR.
          IF AVAILABLE ad_mstr THEN 
          DO:
            RUN pdf_set_font("Spdf","Helvetica",10).
            RUN pdf_text_xy("Spdf",ad_name,250,750).
            RUN pdf_text_xy("Spdf",ad_line1 + "," + ad_line2 + "," + ad_city + "," + ad_zip,120,740).
          END . /* IF AVAILABLE ad_mstr */
         END. /* IF AVAILABLE si_mstr  */
       END. /* IF AVAILABLE tr_hist */
      
      
      FIND FIRST ad_mstr WHERE ad_mstr.ad_addr = ih_cust NO-LOCK NO-ERROR.
      IF AVAILABLE ad_mstr THEN 
      DO:
      
          RUN pdf_set_font("Spdf","Helvetica",8).
          RUN pdf_text_xy("Spdf",ih_cust,80,655).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_name,33,640).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_line1,33,630).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_line2,33,620).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_city + "-" + ad_mstr.ad_zip,33,610).
      END. /* IF AVAILABLE ad_mstr */
      
      FIND FIRST ad_mstr WHERE ad_mstr.ad_addr = ih_ship NO-LOCK NO-ERROR.
      IF AVAILABLE ad_mstr THEN 
      DO:
          RUN pdf_set_font("Spdf","Helvetica",8).
          RUN pdf_text_xy("Spdf",ih_ship,255,655).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_name,213,640).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_line1,213,630).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_line2,213,620).
          RUN pdf_text_xy("Spdf",ad_mstr.ad_city + "-" + ad_mstr.ad_zip,213,610).
      END. /* IF AVAILABLE ad_mstr */ 
   
    END. /* IF first-of THEN */
   
    IF li_count < 5 THEN
    DO:
      
      RUN pdf_set_font("Spdf","Helvetica",10).
      RUN pdf_text_xy("Spdf",idh_line,33,li_text).
      
      FIND FIRST pt_mstr WHERE pt_part = idh_part NO-LOCK NO-ERROR.
      IF AVAILABLE pt_mstr THEN 
      DO:
        RUN pdf_set_font("Spdf","Helvetica",10).
        RUN pdf_text_xy("Spdf",pt_desc1,65,li_text).
      END. /*  IF AVAILABLE pt_mstr */
      
      ELSE
      DO:
        RUN pdf_set_font("Spdf","Helvetica",10).
        RUN pdf_text_xy("Spdf",idh_desc,65,li_text).
      END. /* else */
      
      RUN pdf_set_font("Spdf","Helvetica",10).
      RUN pdf_text_xy("Spdf",idh_part,230,li_text).
      RUN pdf_text_xy("Spdf",idh_qty_inv,320,li_text).
      RUN pdf_text_xy("Spdf",idh_um,385,li_text).
      RUN pdf_text_xy("Spdf",idh_list_pr,420,li_text).
      RUN pdf_text_xy("Spdf",idh_qty_inv * idh_list_pr,490,li_text).
      
      ASSIGN
      li_text = li_text - 15
      li_count = li_count + 1
      li_totalqty = li_totalqty + idh_qty_inv
      li_amount = li_amount + (idh_qty_inv * idh_list_pr).
      
    END. /* IF li_count */
   
    IF LAST-OF(idh_inv_nbr) then do:
        RUN pdf_set_font("Spdf","Helvetica",10).
        RUN pdf_text_xy("Spdf",li_totalqty,320,320).
        RUN pdf_text_xy("Spdf",li_amount,490,320).
        RUN pdf_set_font("spdf","Code39",50).
        RUN pdf_text_xy("spdf","*" + STRING(ih_inv_nbr) + "*",200,150).
    end. /* IF last-of idh_inv_nbr */
   
  END. /* FOR EACH ih_hist */
 
  RUN pdf_close("spdf").
  
  Message "Invoice Has been generated".
  
END. /* REPEAT */