<?php
require("includes/check_auth_user.php");
require("includes/dbconnect.php");
include ('includes/function.php');

$zyear1 = $_SESSION["zdbyear_" . $dbname];
$zroot1 = left($zyear1, -4);
$zyear = substr($zyear1, -4);
$zdir = "";
$dbyear = "fab_year";

$username = $_SESSION["username"];
$cacmst = "accmast";
$cgrpmast = "grpmast";
$cgrphead = "grphead";
$cbrand = "brand";
$cexpense = "expense";
$cgodown = "godown";
$citem = "item";
//$citemsub   = "itemsub";
$cnarration = "narration";
$ctype = "type";
$cstkitem = "transacn";
$cstkitemsub = "itemsub";
$ctrans = "transport";
$caddress = "address";

$zdb = $_SESSION["zdbyear_" . $dbname];
//browse($zdb);
mysqli_select_db($conn, $zdb);

function mysql_current_db() {
    $r = mysqli_query($conn, "SELECT DATABASE()") or die(mysqli_error($conn));
    //browse("Current DB->".mysql_result($r,0));
}

if (isset($_POST["save"])) {
    $fryear = $zroot1 . $_POST["frmyear"];
    $toyear = $zroot1 . $_POST["toyear"];

//    $zyear = right($zdb, 4);
    $mfrdate = getzdates($toyear, 'S');
    $mtodate = getzdates($toyear, 'E');

    /*     * **********Copying **************** */
    browse($fryear);
    browse($toyear);
//    die();
    mysqli_select_db($conn, $fryear);

    $acqry = mysqli_query($conn, "SELECT * FROM `$cacmst`") or die(mysqli_error($conn));
    $addressqry = mysqli_query($conn, "SELECT * FROM `$caddress`") or die(mysqli_error($conn));
    $grpmqry = mysqli_query($conn, "SELECT * FROM `$cgrpmast`") or die(mysqli_error($conn));
    $grpheadqry = mysqli_query($conn, "SELECT * FROM `$cgrphead`") or die(mysqli_error($conn));
    $brandqry = mysqli_query($conn, "SELECT * FROM `$cbrand`") or die(mysqli_error($conn));
    $godownqry = mysqli_query($conn, "SELECT * FROM `$cgodown`") or die(mysqli_error($conn));
    $itemqry = mysqli_query($conn, "SELECT * FROM `$citem`") or die(mysqli_error($conn));
    $narrqry = mysqli_query($conn, "SELECT * FROM `$cnarration`") or die(mysqli_error($conn));
//    $typeqry = mysqli_query($conn, "SELECT * FROM `$ctype`") or die(mysqli_error($conn));
//    $expnqry = mysqli_query($conn, "SELECT * FROM `$cexpense`") or die(mysqli_error($conn));
    $transqry = mysqli_query($conn, "SELECT * FROM `$ctrans`") or die(mysqli_error($conn));
    $shipqry = mysqli_query($conn, "SELECT * FROM `shipmain` where relcheck = ''") or die(mysqli_error($conn));


//    $getitem = mysqli_query($conn, "SELECT *, substr(quality,0,3) as qnmo from item where code in (SELECT itemcode FROM `transacn` a, `item` b 
//                           WHERE a.`itemcode` =  b.`code` AND a.`vouchdt` <= '$asdt' 
//                           $namecond $brandcond $qualitycond $yarncond $typecond $shadecond $qualitycond
//                           GROUP BY a.itemcode, a.shade, a.actbatch having sum(a.totqty) > 1) 
//                           group by code order by qnmo+0, quality, shade+0, name") or die(mysqli_error($conn));

    $stkitqry = mysqli_query($conn, "SELECT itemcode, baleqty, sum(qty) as qty, brand, baleqty,containerno, cost, rate,godown
                                       FROM `transacn` GROUP BY godown, brand, itemcode, cost having sum(qty) != 0   ") or die(mysqli_error($conn));

//    print table($stkitqry);
//    die();
    
    browse('containerent');
    while ($rowcont = mysqli_fetch_assoc($shipqry)) {
        $shpvcno = $rowcont["vouchno"];
        

        mysqli_select_db($conn, $toyear);
        $chkgrhdpmast = mysqli_query($conn, "SELECT * FROM `shipmain` WHERE `vouchno`='$shpvcno'") or die(mysqli_error($conn));
        if (mysqli_num_rows($chkgrhdpmast) > 0) {
            
        } else {
            mysqli_query($conn, "INSERT INTO `shipmain`(`vouchno`, `code`, `vouchdt`, `name`, `container`, `eta`, `live`, `status`, `remark1`, `remark2`,
                                                        `series`, `invno`, `totwt`, `invamt`, `relcheck`, `releasedt`, `docvalue`, `roe`, `inramt`, `delvdt`, `logo`)
                                         select  `vouchno`, `code`, `vouchdt`, `name`, `container`, `eta`, `live`, `status`, `remark1`, `remark2`, 
                                         `series`, `invno`, `totwt`, `invamt`, `relcheck`, `releasedt`, `docvalue`, `roe`, `inramt`, `delvdt`, `logo` from $fryear.shipmain where vouchno = '$shpvcno'") or die(mysqli_error($conn));
        }
    }
    
    browse('grphead');
    while ($rowhead = mysqli_fetch_assoc($grpheadqry)) {
        $grphdsrno = $rowhead["srno"];
        $grphdname = $rowhead["name"];
        $grphdtype = $rowhead["type"];
        $grphdsubtype = $rowhead["subtype"];
        $grphdcode = $rowhead["code"];


        mysqli_select_db($conn, $toyear);
        $chkgrhdpmast = mysqli_query($conn, "SELECT * FROM `$cgrphead` WHERE `code`='$grphdcode'") or die(mysqli_error($conn));
        if (mysqli_num_rows($chkgrhdpmast) > 0) {
            mysqli_query($conn, "UPDATE `$cgrphead` SET `name`='$grphdname', `type`='$grphdtype', `subtype`='$grphdsubtype'
                                                        WHERE code='$grphdcode'") or die(mysqli_error($conn));
        } else {
            mysqli_query($conn, "INSERT INTO `$cgrphead`(`srno`, `code`, `name`, `type`, `subtype`)
                                          VALUES('$grphdsrno', '$grphdcode', '$grphdname', '$grphdtype', '$grphdsubtype')") or die(mysqli_error($conn));
        }
    }
//
    browse('grpmast');
    while ($row2 = mysqli_fetch_assoc($grpmqry)) {
        $grpcode = $row2["grpcode"];
        $name2 = $row2["name"];
        $type = $row2["type"];
        $subtype = $row2["subtype"];
        $add_info = $row2["add_info"];
        $initial = $row2["initial"];
        $headcode = $row2["headcode"];

        mysqli_select_db($conn, $toyear);
        $chkgrpmast = mysqli_query($conn, "SELECT * FROM `$cgrpmast` WHERE `grpcode`='$grpcode'") or die(mysqli_error($conn));
        if (mysqli_num_rows($chkgrpmast) > 0) {
            mysqli_query($conn, "UPDATE `$cgrpmast` SET `name`='$name2', `type`='$type', `subtype`='$subtype', `add_info`='$add_info', `initial`='$initial',
                                                         headcode='$headcode' WHERE grpcode='$grpcode'") or die(mysqli_error($conn));
        } else {
            mysqli_query($conn, "Insert into $toyear.$cgrpmast Select * from $fryear.$cgrpmast where grpcode='$grpcode'") or die(mysqli_error($conn));

//            mysqli_query($conn, "INSERT INTO `$cgrpmast`(`grpcode`, `name`, `type`, `subtype`, `add_info`, `initial`, headcode)
//                                                 VALUES('$grpcode', '$name2', '$type', '$subtype', '$add_info', '$initial', '$headcode')") or die(mysqli_error($conn));
        }
    }
    browse('accmast');

////    /*     * **********accmast **************** */
    while ($row = mysqli_fetch_assoc($acqry)) {
        $accode = $row["accode"];
        $name = mysqli_real_escape_string($conn, $row["name"]);
//        $consname = $row["consname"];
        $add1 = mysqli_real_escape_string($conn, $row["add1"]);
        $add2 = mysqli_real_escape_string($conn, $row["add2"]);
        $add3 = mysqli_real_escape_string($conn, $row["add3"]);
//        $add4 = $row["add4"];
        $grpcode = $row["grpcode"];
        $custtype = $row["custtype"];
        $custcode = $row["custcode"];
        $deptcode = $row["deptcode"];
        $nameprin = $row["nameprin"];
        $type = $row["type"];
        $init = $row["init"];
        $bankinit = $row["bankinit"];
        $tinno = $row["tinno"];
        $city = $row["city"];
        $pin = $row["pin"];
        $country = $row["country"];
        $station = $row["station"];
        $tel = $row["tel"];
        $fax = $row["fax"];
        $mobile = $row["mobile"];
        $mobile2 = $row["mobile2"];
        $email = $row["email"];
        $openbal = $row["openbal"];
        $dc = $row["dc"];
        $owner = $row["owner"];
        $creditlimit = $row["credlimit"];
        $website = $row["website"];
        $contpers = $row["contpers"];
        $vattin = $row["vattin"];
        $csttin = $row["csttin"];
        $pattern = $row["pattern"];
        $closbal = $row["closbal"];
        $closbdc = $row["closbdc"];
        $pfund = $row["pfund"];
        $saltype = $row["saltype"];
        $salwise = $row["salwise"];
        $salmon = $row["salmon"];
        $travmon = $row["travmon"];
        $convmon = $row["convmon"];
        $p_tax = $row["p_tax"];
        $leaveflag = $row["leaveflag"];
        $leavecode = $row["leavecode"];
        $esic = $row["esic"];
        $salary = $row["salary"];
        $active = $row["active"];
        $username = $row["username"];
        $pan = $row["pan"];
        $staff = $row["staff"];
        $transporter = $row["transporter"];
//        $transport = $row["transport"];
        $lbt = $row["lbt"];
        $password = $row["password"];
        $confpass = $row["confpass"];
        $broker = $row["broker"];
        $gstno = $row["gstno"];
//        $discount = $row["discount"];
//        $commperc = $row["commperc"];
//        $ledgfrom = $row["ledgfrom"];
//        $ledgto = $row["ledgto"];

        if ($dc == "D") {
            $nopen = abs($openbal) * -1;
        } else {
            $nopen = abs($openbal);
        }
//        if ($accode == "51") {
//            mysql_current_db();
//        }


        mysqli_select_db($conn, $fryear);
        $actranqry = mysqli_query($conn, "SELECT SUM(amount) AS amt FROM `actran` WHERE accode='$accode' AND `chqret` !='Y'") or die(mysqli_error($conn));
        $get = mysqli_fetch_assoc($actranqry);
        $balamt = $get["amt"];

        $topen = $nopen + $balamt;

        if ($topen > 0) {
            $tdc = "C";
        } else {
            $tdc = "D";
        }

        $topen = abs($topen);


        $gettypeqry = mysqli_query($conn, "SELECT * FROM $fryear.$cgrpmast WHERE grpcode='$grpcode'") or die(mysqli_error($conn));
        $fettype = mysqli_fetch_array($gettypeqry);
        $mgtype = $fettype['type'];



        $mamt = 0;
        if ($mgtype != "I" && $mgtype != "E") {
            $getamtqry = mysqli_query($conn, "SELECT sum(amount) as tamt FROM $fryear.actran WHERE accode='$accode' and retdate = '0000-00-00' ") or die(mysqli_error($conn));
            $fetamt = mysqli_fetch_array($getamtqry);
            $mamt = $fetamt['tamt'];
        } else {
            $mamt = 0;
        }
        if ($grpcode == '050' and $percent > 0) {
            $mpl = $mprof * ($percent / 100);
        } else {
            $mpl = 0;
        }

        if ($mgtype != "I" && $mgtype != "E") {
            switch ($accode) {
                case '7':
                    $closbal = $openbal + $currbal;
                    break;
                case '23':
                    $closbal = $openbal + $currbal;
                    break;
                case '24':
                    break;

                default:
                    $currbal = $mamt;
                    $closbal = $openbal + $currbal + $mpl;


                    break;
            }
        } else {
            $currbal = 0.00;
            $closbal = 0.00;
        }

        if ($currbal > 0) {
            $currdc = "C";
        } else {
            $currdc = "D";
        }

        if ($grpcode == '050') {
            if ($closbal < 0) {
                $closbdc = "C";
            } else {
                $closbdc = "D";
            }
        } ELSE {
            if ($closbal > 0) {
                $closbdc = "C";
            } else {
                $closbdc = "D";
            }
        }


        /*        if($accode=="51"){
          browse($balamt);
          browse($nopen);
          browse($topen);
          browse($tdc);
          } */

        mysqli_select_db($conn, $toyear);
        $chkac = mysqli_query($conn, "SELECT * FROM `$cacmst` WHERE accode = '$accode'");
        if (mysqli_num_rows($chkac) > 0) {
            mysqli_query($conn, "UPDATE `$cacmst` SET `name`='$name', `add1`='$add1', `add2`='$add2', `add3`='$add3',
                                           `grpcode`='$grpcode', `custtype`='$custtype', `custcode`='$custcode', `deptcode`='$deptcode', 
                                           `nameprin`='$nameprin', `type`='$type', `init`='$init', `bankinit`='$bankinit', `tinno`='$tinno', `city`='$city',  
                                           `pin`='$pin', `country`='$country',  `tel`='$tel', `fax`='$fax', `mobile`='$mobile',
                                           `mobile2`='$mobile2', `email`='$email', openbal='$topen', `dc`='$tdc', `owner`='$owner',credlimit='$creditlimit',
                                           `website`='$website', `contpers`='$contpers', `vattin`='$vattin', `csttin`='$csttin',
                                           `pattern`='$pattern', closbal='$closbal', `closbdc`='$closbdc', `pfund`='$pfund',
                                           `saltype`='$saltype', `salwise`='$salwise', salmon='$salmon', travmon='$travmon',
                                            convmon='$convmon', `p_tax`='$p_tax', `leaveflag`='$leaveflag', `leavecode`='$leavecode',
                                           `esic`='$esic', salary='$salary', active='$active', `username`='$username', 
                                           `pan`='$pan', staff='$staff', transporter ='$transporter', password='$password', `confpass`='$confpass', `broker`='$broker',
                                           `lbt`='$lbt', `gstno`='$gstno' WHERE accode = $accode") or die(mysqli_error($conn));
        } else {
            mysqli_query($conn, "Insert into $toyear.$cacmst Select * from $fryear.$cacmst where accode='$accode'") or die(mysqli_error($conn));

            mysqli_query($conn, "UPDATE $toyear.$cacmst SET openbal='$topen', `dc`='$tdc',closbal='$closbal',closbdc='$closbdc' WHERE accode = '$accode'") or die(mysqli_error($conn));
//            mysqli_query($conn, "INSERT INTO `$cacmst`(`accode`,`name`, `add1`, `add2`, `add3`, `grpcode`, `custtype`, `custcode`, `deptcode`,
//                                               `nameprin`, `type`, `init`, `bankinit`, `tinno`, `city`, `pin`, `country`, `station`, `tel`, `fax`,
//                                                `mobile`, `mobile2`, `email`, openbal, `dc`, `owner`, credlimit, `website`, `contpers`, 
//                                               `vattin`, `csttin`, `pattern`, closbal, `closbdc`, `pfund`, `saltype`, `salwise`, salmon, 
//                                                travmon, convmon, `p_tax`, `leaveflag`, `leavecode`, `esic`, salary, active, `username`, `pan`,
//                                                staff, transporter, `lbt`, `password`, `confpass`, `broker`, `gstno`)
//   
//                                        VALUES('$accode', '$name', '$add1', '$add2', '$add3', '$grpcode', '$custtype', '$custcode', '$deptcode',
//                                               '$nameprin', '$type', '$init', '$bankinit', '$tinno', '$city', '$pin', '$country', '$station', '$tel', '$fax', 
//                                               '$mobile', '$mobile2', '$email', '$topen', '$tdc', '$owner', '$website', '$creditlimit', '$contpers', 
//                                               '$vattin', '$csttin', '$pattern', '$closbal', '$closbdc', '$pfund', '$saltype', '$salwise', '$salmon', 
//                                               '$travmon', '$convmon', '$p_tax', '$leaveflag', '$leavecode', '$esic', '$salary', '$active', '$username', '$pan', 
//                                               '$staff', '$transporter', '$lbt', '$password', '$confpass', '$broker', '$gstno')") or die(mysqli_error($conn));
        }
    }
//    

    browse('tranasacn');

    mysqli_select_db($conn, $toyear);
    mysqli_query($conn, "delete from `$cstkitemsub`  ") or die(mysqli_error($conn));
    mysqli_query($conn, "delete from `$cstkitem` where source = 'OP' ") or die(mysqli_error($conn));

    $cnt = 0;

    while ($rowst = mysqli_fetch_assoc($stkitqry)) {
        $cnt++;
        $source = $rowst["source"];
        $yearno = $rowst["yearno"];
        $groupt = $rowst["group"];
        $type = $rowst["type"];
        $vouchno = $rowst["vouchno"];

        $vouchdt = $rowst["vouchdt"];

        $srno = $rowst["srno"];
        $brandd = $rowst["brand"];
        $itmtcode = $rowst["itemcode"];
        $itmtname = $rowst["itemname"];
        $shadet = $rowst["shade"];
        $batcht = $rowst["batch"];
        $takat = $rowst["taka"];
        $qtyt = $rowst["qty"];
        $mrate = $rowst["rate"];
        $totqtyt = $rowst["ttotqty"];
        $actqtyt = $rowst["tactqty"];
        $flagqtyt = $rowst["tflagqty"];
        $flagqt = $rowst["flag"];
        $ordt = $rowst["ord"];
        $godownt = $rowst["godown"];
        $actbatcht = $rowst["actbatch"];
        $salemodet = $rowst["salemode"];
        $mbaleqty = $rowst["baleqty"];
        $mcost = $rowst["cost"];
        $mgodown = $rowst["godown"];
        $mtotqty = $qtyt * $mbaleqty;
        $group = 'OP' . $itmtcode;
//        $actbatch = 'OP' . $itmtcode . $batcht;

        if ($qtyt != 0) {


//            mysqli_query($conn, "INSERT INTO `$cstkitemsub`(`srno`, `code`,  `batch`, `taka`, `qty`, `totqty`, `actqty`, `flag`, 
//                                                 `flagqty`, `godown`)
//                                         VALUES ('$srno', '$itmtcode','$actbatcht','$takat','$qtyt','$totqtyt','$actqtyt','$flagqt',
//                                                 '$flagqtyt','$godownt')") or die(mysqli_error($conn));

            mysqli_query($conn, "INSERT INTO `$cstkitem`(`yearno`, `group`, `source`, `type`,`vouchno`,`vouchdt`,
                            `srno`, `brand`, `itemcode`,`itemname`,`batch`, `taka`, `qty`, `cost`, baleqty, 
                            `totqty`, `flag`, `flagqty`, `actqty`,  `actbatch`,`ord`,`shade`,containerno, `rate`, `currency`, `godown`)
                     VALUES('$yearno','$group','OP','$type','','0000-00-00', '$srl','$brandd',
                            '$itmtcode', '$mitem', '$mbatch', '$mtaka', '$qtyt', '$mcost', '$mbaleqty', '$mtotqty', 
                            '$mflag', '$mflagqty','$minvqty', '$mactbatch','$ord','$mshade','$containerno', '$mrate', 'USD', '$mgodown')") or die(mysqli_error($conn));

        }
    }



    browse('brand');

    while ($rowbrand = mysqli_fetch_assoc($brandqry)) {
        $brndsrl = $rowbrand["srl"];
        $brndcode = $rowbrand["code"];
        $brndname = $rowbrand["name"];

        $chkbrand = mysqli_query($conn, "SELECT * FROM `$cbrand` WHERE `code`='$brndcode'") or die(mysqli_error($conn));
        if (mysqli_num_rows($chkbrand) > 0) {
            mysqli_query($conn, "UPDATE `$cbrand` SET `name`='$brndname' WHERE code='$brndcode'") or die(mysqli_error($conn));
        } else {
            mysqli_query($conn, "Insert into $toyear.$cbrand Select * from $fryear.$cbrand where code='$brndcode'") or die(mysqli_error($conn));

//            mysqli_query($conn, "INSERT INTO `$cbrand`(`code`, `name`)
//                                     VALUES('$brndcode', '$brndname')") or die(mysqli_error($conn));
        }
    }
//
//
//    while ($rowexpns = mysqli_fetch_assoc($expnqry)) {
//        $expsrl = $rowexpns["srl"];
//        $expcode = $rowexpns["code"];
//        $expname = $rowexpns["name"];
//
//        $chkexpense = mysqli_query($conn, "SELECT * FROM `$cexpense` WHERE `code`='$expcode'") or die(mysqli_error($conn));
//        if (mysqli_num_rows($chkexpense) > 0) {
//            mysqli_query($conn, "UPDATE `$cexpense` SET `name`='$expname' WHERE code='$expcode'") or die(mysqli_error($conn));
//        } else {
//            mysqli_query($conn, "Insert into $toyear.$cexpense Select * from $fryear.$cexpense where code='$expcode'") or die(mysqli_error($conn));
//
////            mysqli_query($conn, "INSERT INTO `$cexpense`(`code`, `name`)
////                                     VALUES('$expcode', '$expname')") or die(mysqli_error($conn));
//        }
//    }
//
//    browse('transport');
//
//    while ($rowtrns = mysqli_fetch_assoc($transqry)) {
//        $trnscode = $rowtrns["code"];
//        $trnsname = $rowtrns["name"];
//        $trnsadd1 = $rowtrns["add1"];
//        $trnsadd2 = $rowtrns["add2"];
//        $trnsadd3 = $rowtrns["add3"];
//        $trnscity = $rowtrns["city"];
//        $trnspin = $rowtrns["pin"];
//        $trnscntry = $rowtrns["country"];
//        $trnstel = $rowtrns["tel"];
//        $trnsfax = $rowtrns["fax"];
//        $trnsmobile = $rowtrns["mobile"];
//        $trnsmobile2 = $rowtrns["mobile2"];
//        $trnsemail = $rowtrns["email"];
//
//
//
////        mysqli_query($conn, "Delete from $toyear.$ctrans where code = '$trnscode'") or die(mysqli_error($conn));
////
////        mysqli_query($conn, "Insert into $toyear.$ctrans select * from $fryear.$ctrans where code = '$trnscode'") or die(mysqli_error($conn));
//        $chktrans = mysqli_query($conn, "SELECT * FROM `$ctrans` WHERE `code`='$trnscode'") or die(mysqli_error($conn));
//        if (mysqli_num_rows($chktrans) > 0) {
//            mysqli_query($conn, "UPDATE `$ctrans` SET `name`='$trnsname', `add1`='$trnsadd1', `add2`='$trnsadd2', `add3`='$trnsadd3',
//                                           `city`='$trnscity', `pin`='$trnspin', `country`='$trnscntry',  `tel`='$trnstel', `fax`='$trnsfax', `mobile`='$trnsmobile',
//                                           `mobile2`='$trnsmobile2', `email`='$trnsemail'  WHERE code = '$trnscode'") or die(mysqli_error($conn));
//        } else {
//            mysqli_query($conn, "Insert into $toyear.$ctrans Select * from $fryear.$ctrans where code='$trnscode'") or die(mysqli_error($conn));
//
////            mysqli_query($conn, "INSERT INTO `$ctrans`(`code`, `name`, `add1`, `add2`, `add3`, 
////                                               `city`, `pin`, `country`, `tel`, 
////                                               `fax`, `mobile`, `mobile2`, `email`)
////   
////                                        VALUES('$trnscode', '$trnsname', '$trnsadd1', '$trnsadd2', '$trnsadd3', 
////                                               '$trnscity', '$trnspin', '$trnscntry',  '$trnstel', '$trnsfax', 
////                                               '$trnsmobile', '$trnsmobile2', '$trnsemail' )") or die(mysqli_error($conn));
//        }
//    }
//
//
    browse('godown');
    while ($rowgdwn = mysqli_fetch_assoc($godownqry)) {
        $gdwncode = $rowgdwn["code"];
        $gdwngocode = $rowgdwn["gocode"];
        $gdwnname = $rowgdwn["name"];
        $gdwnadd1 = $rowgdwn["add1"];
        $gdwnadd2 = $rowgdwn["add2"];
        $gdwnadd3 = $rowgdwn["add3"];
        $gdwncity = $rowgdwn["city"];
        $gdwnpin = $rowgdwn["pin"];
        $gdwncntry = $rowgdwn["country"];
        $gdwntel = $rowgdwn["tel"];
        $gdwnfax = $rowgdwn["fax"];
        $gdwnmobile = $rowgdwn["mobile"];
        $gdwnmobile2 = $rowgdwn["mobile2"];
        $gdwnemail = $rowgdwn["email"];


        mysqli_select_db($conn, $toyear);
        $chkgodown = mysqli_query($conn, "SELECT * FROM `$cgodown` WHERE `code`='$gdwncode'") or die(mysqli_error($conn));
        if (mysqli_num_rows($chkgodown) > 0) {
            mysqli_query($conn, "UPDATE `$cgodown` SET `gocode`='$gdwngocode', `name`='$gdwnname', `add1`='$gdwnadd1', `add2`='$gdwnadd2', `add3`='$gdwnadd3',
                                           `city`='$gdwncity', `pin`='$gdwnpin', `country`='$gdwncntry',  `tel`='$gdwntel', `fax`='$gdwnfax', `mobile`='$gdwnmobile',
                                           `mobile2`='$gdwnmobile2', `email`='$gdwnemail'  WHERE gocode = '$gdwncode'") or die(mysqli_error($conn));
        } else {
            mysqli_query($conn, "Insert into $toyear.$cgodown Select * from $fryear.$cgodown where code='$gdwncode'") or die(mysqli_error($conn));

//            mysqli_query($conn, "INSERT INTO `$cgodown`(`code`, `gocode`, `name`, `add1`, `add2`, `add3`, 
//                                               `city`, `pin`, `country`, `tel`, 
//                                               `fax`, `mobile`, `mobile2`, `email`)
//   
//                                        VALUES('$gdwncode', '$gdwngocode', '$gdwnname', '$gdwnadd1', '$gdwnadd2', '$gdwnadd3', 
//                                               '$gdwncity', '$gdwnpin', '$gdwncntry', '$gdwntel', '$gdwnfax', 
//                                               '$gdwnmobile', '$gdwnmobile2', '$gdwnemail' )") or die(mysqli_error($conn));
        }
    }
//

    browse("item");
    while ($rowitm = mysqli_fetch_assoc($itemqry)) {
        $itmbarcode = $rowitm["barcode"];
        $itmcode = $rowitm["code"];
        $itmqual = $rowitm["quality"];
        $itmshade = $rowitm["shade"];
        $itmyarn = $rowitm["yarn"];
        $itmname = $rowitm["name"];
        $itmtype = $rowitm["type"];
        $itmunit = $rowitm["unit"];
        $itmbrand = $rowitm["brand"];
        $itmsalemode = $rowitm["salemode"];
        $itmcost = $rowitm["cost"];
        $itmselling = $rowitm["selling"];
        $itmhsncode = $rowitm["hsncode"];
        $itmgstperc = $rowitm["gstperc"];
        $itmofs = $rowitm["ofs"];
        $itmother = $rowitm["other"];
        
//        browse($itmname);

        $chkitem = mysqli_query($conn, "SELECT * FROM `$citem` WHERE `code`='$itmcode' and `brand`='$itmbrand' ") or die(mysqli_error($conn));
        if (mysqli_num_rows($chkitem) > 0) {
            mysqli_query($conn, "UPDATE `$citem` SET `name`='$itmname',`type`='$itmtype',
                    `unit`='$itmunit',`brand`='$itmbrand',`salemode`='$itmsalemode',
                    `hsncode`='$itmhsncode',`gstperc`='$itmgstperc',`ofs`='$itmofs',
                    `other`='$itmother' WHERE `code`='$itmcode' and `brand`='$itmbrand' ") or die(mysqli_error($conn));
        } else {
            mysqli_query($conn, "Insert into $toyear.$citem Select * from $fryear.$citem where `code`='$itmcode' and `brand`='$itmbrand' ") or die(mysqli_error($conn));

//            mysqli_query($conn, "INSERT INTO `$citem`(`code`, `quality`, `shade`, `yarn`, `name`, `type`, `unit`, `brand`, 
//                                           `salemode`, `cost`, `selling`, `hsncode`, `gstperc`)
//                                    VALUES ('$itmcode','$itmqual','$itmshade','$itmyarn','$itmname','$itmtype', '$itmunit','$itmbrand',
//                                            '$itmsalemode','$itmcost','$itmselling', '$itmhsncode', '$itmgstperc')") or die(mysqli_error($conn));
        }
    }
//
//
//
//    while ($rownarr = mysqli_fetch_assoc($narrqry)) {
//        $narrsrl = $rownarr["srl"];
//        $narrcode = $rownarr["code"];
//        $narrname = $rownarr["name"];
//
//        $chknarration = mysqli_query($conn, "SELECT * FROM `$cnarration` WHERE `code`='$narrcode'") or die(mysqli_error($conn));
//        if (mysqli_num_rows($chknarration) > 0) {
//            mysqli_query($conn, "UPDATE `$cnarration` SET `name`='$narrname' WHERE code='$narrcode'") or die(mysqli_error($conn));
//        } else {
//            mysqli_query($conn, "Insert into $toyear.$cnarration Select * from $fryear.$cnarration where code='$narrcode'") or die(mysqli_error($conn));
//
////            mysqli_query($conn, "INSERT INTO `$cnarration`(`code`, `name`)
////                                     VALUES('$narrcode', '$narrname')") or die(mysqli_error($conn));
//        }
//    }
//
//    browse('type');
//
//    while ($rowtype = mysqli_fetch_assoc($typeqry)) {
//        $typsrl = $rowtype["srl"];
//        $typcode = $rowtype["code"];
//        $typname = $rowtype["name"];
//
//        $chktypest = mysqli_query($conn, "SELECT * FROM `$ctype` WHERE `code`='$typcode'") or die(mysqli_error($conn));
//        if (mysqli_num_rows($chktypest) > 0) {
//            mysqli_query($conn, "UPDATE `$ctype` SET `name`='$typname' WHERE code='$typcode'") or die(mysqli_error($conn));
//        } else {
//            mysqli_query($conn, "Insert into $toyear.$ctype Select * from $fryear.$ctype where code='$typcode'") or die(mysqli_error($conn));
//
////            mysqli_query($conn, "INSERT INTO `$ctype`(`code`, `name`)
////                                     VALUES('$typcode', '$typname')") or die(mysqli_error($conn));
//        }
//    }



    browse("Processing Complete");
    header("refresh: 1;yearend.php");
}
include("includes/linkshead.php");
?>



</head>
<body onLoad="">
    <form action=''  name="yearend" method="POST">
        <div class="panel-body" style="border: 1px solid black;">
            <div class="row">
                <div class="col-lg-12" style=''>
                    <div class="row">
                        <div class="col-lg-2"></div>
                        <div class="col-lg-2 text-right">
                            <label class="control-label">From Year</label>
                        </div>
                        <div class="col-lg-2">
                            <select name="frmyear" class="form-control" >
                                <?php
                                require("includes/dbconnect.php");

                                $fyear = mysqli_query($conn, "SELECT * FROM `compyear` where finyear = '$zyear' order by `lastdate` DESC") OR die(mysqli_error($conn));
                                while ($rowf = mysqli_fetch_array($fyear)) {
                                    echo "<option value=\"$rowf[finyear]\">$rowf[finyear]</option>";
                                }
                                ?>
                            </select>
                        </div>

                    </div>
                    <br>
                    <div class="row">
                        <div class="col-lg-2"></div>
                        <div class="col-lg-2 text-right">
                            <label class="control-label">To Year</label>
                        </div>
                        <div class="col-lg-2">
                            <select name="toyear" class="form-control" >
                                <?php
//                            require("includes/dbconnect.php");
                                $tyear = mysqli_query($conn, "SELECT * FROM `compyear` WHERE finyear !='$zyear'  ORDER BY `lastdate`") OR die(mysqli_error($conn));
                                while ($rowt = mysqli_fetch_array($tyear)) {
                                    echo "<option value=\"$rowt[finyear]\">$rowt[finyear]</option>";
                                }
                                ?>
                            </select>
                        </div>

                    </div>
                    <br>
                    <br>
                    <div class="row">
                        <div class="col-lg-4"></div>
                        <div class="col-lg-2">
                            <input type="submit" name="save" value="Proceed" class="btn btn-primary">
                            <!--<input type="button" name="exit" value="Exit" class="btn btn-danger" href="default.php">-->
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </form>
    <?php include("includes/linksfoot.php"); ?>
</body>
</html>