<?
include_once("../lib/bill.php");
include_once("../tbs/tbs_class.php");
include_once("facturepdf.php");

$customerid=$_GET["customerid"];
$id_line=$_GET['id'];
$action=$_GET['action'];

if ($action=='moveUP') {
$sql="update orders_lines set status=11 where id=$id_line";
$result = mysql_query($sql,$billDBConn);
}
elseif ($action=='moveDN') {
$sql="update orders_lines set status=10 where id=$id_line";

$result = mysql_query($sql,$billDBConn);
}
elseif ($action=='bill') {
$bill=getCurrentBillable($customerid,false);

if ( count($bill)==0 ) die("Il n'y a rien &agrave; facturer !!");



// create new bill
$sql="insert into invoices (id_customer,date) values ($customerid,CURDATE())";
$result = mysql_query($sql,$billDBConn) or die(mysql_error());
$id_invoice=mysql_insert_id();

// copy lines from orders_lines to invoices_lines

for($i=0;$i<count($bill);$i++) {
$keyvals=array(
"id_invoice"=>$id_invoice,
"id_order_line"=>$bill[$i]["id_order_line"],
"description"=>$bill[$i]["description"],
"quantity"=>$bill[$i]["quantity"],
"price"=>$bill[$i]["price"],
"tva_rate"=>$bill[$i]["tva_rate"],
"tva_amt"=>$bill[$i]["tva_amt"]
);

// add line to invoice
$sql=genInsertSQLString("invoices_lines",$keyvals);
$result = mysql_query($sql,$billDBConn) or die($sql."<br>".mysql_error());

// update status of the order line
$sql="update orders_lines set status=20 where status<>21 and id=".$bill[$i]["id_order_line"];
$result = mysql_query($sql,$billDBConn) or die($sql."<br>".mysql_error());

}


// creation de la facture pdf
$texte_echeance=$config["echeance_facture"][$_GET["echeance"]];

$pdfbuffer=addslashes(makeBillPDF($id_invoice,null,$texte_echeance));
$sql="update invoices set pdf='$pdfbuffer' where id=$id_invoice";
$result = mysql_query($sql,$billDBConn) or die($sql."<br>".mysql_error());

// on montre la facture
$javascript="window.open('factures_view.php?id=$id_invoice');";

} // end action=bill



$cust=new customer($customerid);

$tbs = new clsTinyButStrong ;
$tbs->LoadTemplate("factures_current.html");

// liste a facturer
$bill=getCurrentBillable($customerid,false);
$totalbillable=0;
foreach($bill as $value) {
$totalbillable+=$value["total"];
}
$tbs->MergeBlock("rsbill","array",$bill);

// liste en suspens
$bill=getCurrentBillable($customerid,true);
$totalnotbillable=0;
foreach($bill as $value) {
$totalnotbillable+=$value["total"];
}
$tbs->MergeBlock("rsnotbill","array",$bill);
$tbs->MergeBlock('echeances',$config["echeance_facture"]) ;
$tbs->Show();

?>