CK
%d|%s",$c,$hl)));
}
/*rapor dosyasını açalım içinme rapor yaqzıcazzzz*/
$fout=fopen($reportfile,"w");
/*rapor kolonlarin basliklari ne olacak*/
$str[0]="Kodu"; $str[1]="Adı"; $str[2]="Adres";$str[3]="Şehir";$str[4]="Tel-1";$str[5]="Tel-2";$str[6]="Tel-3";
writeHeaderNames($fout,$str);
$tarih1='D|Başlangıç tarih:|30|2|';
$tarih2='D|Bitiş tarih:|30|2|';
$kusurat=0;
$str1=sprintf("
select distinct code from clitrans where clitrans.code>''
and clitrans.fdate>='%s 00:00:00' and clitrans.fdate <='%s 23:59:59' ",$tarih1,$tarih2);
echo $str1."\n";
$str2=sprintf("
select ic.code,ic.name,ic.address1,ic.address2,ic.city,ic.tel1,ic.tel2,ic.tel3
from clicards ic where %s ","CK");
echo $str2."\n";
$dbh = ibase_connect ($servern, $suser, $spass,'WIN1254');
if($dbh)
{
//get sales cards
$sth = ibase_query ($dbh, $str1);
if($sth){
$toplam1=0;
while ($row = ibase_fetch_row ($sth))
//$itvals[$toplam1++]=trim($row[0]);
$itvals[trim($row[0])]=1;
}
$sth = ibase_query ($dbh, $str2);
if($sth)
{
$toplam1=0;
$t_g=0.0; $t_c=0.0;
while ($row = ibase_fetch_row ($sth))
{
if($itvals[trim($row[0])])continue;
writeCellLine($fout,sprintf("%s|%s|%s|%s|%s|%s|%s|||||||",
trim($row[0]),trim($row[1]),trim($row[2])." ".trim($row[3]),
trim($row[4]),trim($row[5]),trim($row[6]),trim($row[7])
));
$toplam1++;
}
writeLine($fout,sprintf("Toplam kayıt : %s",$toplam1));
}
ibase_close ($dbh);
}
fclose($fout);
?>