SET @TANGGAL = '2005-01-01'
SELECT * FROM TrJual WHERE Tanggal < @TANGGAL
UNION
SELECT * FROM TrRetur WHERE Tanggal < @TANGGAL

SET @TANGGAL = '2005-01-01';
SELECT * FROM TrJual WHERE Tanggal < @TANGGAL
UNION
SELECT * FROM TrRetur WHERE Tanggal < @TANGGAL

CREATE PROCEDURE `sp_postedkaskecil`(IN tanggal DATE, IN nogudang INTEGER)
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
begin

declare fidcompany,fidgudang,fidcoadebet,fidcoacredit,fidcashbookmin int;
declare fdebet,fcredit double(15,0);
declare ckaskeciljurnal cursor for
select idcompany,idgudang,idcash_book_min,debet,credit,idcoa_debet,idcoa_credit from
cash_book_min where idgudang=nogudang and
tgl=tanggal and is_posted=1;

declare exit handler for not found begin end;
open ckaskeciljurnal;
loop
fetch ckaskeciljurnal into fidcompany,
fidgudang,fidcashbookmin,fdebet,fcredit,fidcoadebet,fidcoacredit;
begin
declare fkodecompany varchar(125);
declare fidjurnal,fidjurnalno,nocompany int;
declare fjurnalno varchar(255);
select idcompany into nocompany from gudang where
idgudang=nogudang;
select kode into fkodecompany from
master_company where idcompany=nocompany;
select concat('JU','-',fkodecompany,'-',lpad(
ifnull(max(idjurnal_no),0)+1,7,'0000000'),'-',date_format(tanggal,'%y')),
ifnull(max(idjurnal_no),0)+1
into FJurnalno,fidjurnalno from coa_jurnal where ti=year(tanggal) and idcompany=nocompany;
select ifnull(max(idcoa_jurnal),0)+1 into fidjurnal from coa_jurnal;
insert into coa_jurnal(idcoa_jurnal,
tgl,idjurnal_no,ti,
idcompany,jurnal_no) values(
fidjurnal,tanggal,fidjurnalno,
year(tanggal),
nocompany,fjurnalno);

begin
insert into coa_jurnal_det(idcoa_jurnal,idcompany,idcoa,
debet,credit,iddokumen,idjns) values(fidjurnal,
fidcompany,
fidcoadebet,fdebet,0,fidcashbookmin,11);
insert into coa_jurnal_det(idcoa_jurnal,idcompany,idcoa,
debet,credit,iddokumen,idjns) values(fidjurnal,
fidcompany,
fidcoacredit,0,fcredit,fidcashbookmin,11);






end;

end;
end loop;



end;