#! /usr/bin/awk -f

# k6h2psql.awk
# Jorge Fco. Ricarte Lopez                              
# Mon Oct 15 17:06:50 MDT 2007
# jorgericarte@asuni.com.mx
# Ultimo cambio: Tue 16 Oct 2007 11:25:48 AM MDT
# Kardex historico de seis ultimos meses

BEGIN {
FS=":"
"date +%Y%m%d" | getline mHoy
INSFAC="( kh_gpo, kh_numpar, kh_descrip, kh_tipo, kh_univen1, kh_unicom1, kh_impven1, kh_univen2, kh_cosven2, kh_impven2, kh_unicom2, kh_coscom2, kh_univen3, kh_cosven3, kh_impven3, kh_unicom3, kh_coscom3, kh_univen4, kh_cosven4, kh_impven4, kh_unicom4, kh_coscom4, kh_univen5, kh_cosven5, kh_impven5, kh_unicom5, kh_coscom5, kh_univen6, kh_cosven6, kh_impven6, kh_unicom6, kh_coscom6 )"
CI=2
CF=32
m1=""
}

function fDate(fEsDat)
{
  if (fEsDat==" " || fEsDat=="") { fEsDat=mHoy }
  lnum=sprintf(",'%s'",fEsDat)   
  return lnum
}

function fNumero(fEsNum)
{
  if (fEsNum==0 || fEsNum==" " || fEsNum=="" ) { fEsNum=0 }
  lnum=sprintf(",%2.2f",fEsNum)   
  return lnum
}

function fChar(fEsChr)
{
  lnum=sprintf("'%s'",fEsChr)
  return lnum
}

{
    print ("INSERT INTO ")(K6M)(INSFAC)(" VALUES ( ")\
          ( fChar($1)(",")fChar($2)(",")fChar($3)(",")fChar($4)\
            fNumero($5)fNumero($6)fNumero($7)\
            fNumero($8)fNumero($9)fNumero($10)fNumero($11)fNumero($12)\
            fNumero($13)fNumero($14)fNumero($15)fNumero($16)fNumero($17)\
            fNumero($18)fNumero($19)fNumero($20)fNumero($21)fNumero($22)\
            fNumero($23)fNumero($24)fNumero($25)fNumero($26)fNumero($27)\
            fNumero($28)fNumero($29)fNumero($30)fNumero($31)fNumero($32)\
             )(" );") 
}

END {
#print mHoy
}