Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
~58 People Reached
Favorite Forums
|
$pdf->Table('select @N:=@N+1 AS no, A.department as "DEPARTMENT", A.no as "ASSET NUMBER" , A.total as "ASSET TOTAL PRICE" , B.no as "INVENTORY NUMBER" , B.total as "INVENTORY TOTAL PRICE" from (select h.department , coalesce(count(h.id),0) as no,coalesce(sum(h.price),0) as total from asset h where h.department = "'.$department.'" and year(h.date_accepted) = '.$year.' GROUP BY … |