$orderby = "EMP_ID3"; } # calculate received money by Employees $result = mysql_query("select SUM(AMOUNT),AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='C' GROUP BY AC_ID5 order by PARTY", $db); checkMySQLError(); while ($row = mysql_fetch_array($result)) { $receive_array[$row["AC_ID5"]] = $row["SUM(AMOUNT)"]; } # calculate paid_back money $result = mysql_query("select SUM(AMOUNT),PARTY, AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='D' GROUP BY PARTY order by PARTY", $db); checkMySQLError(); while ($row = mysql_fetch_array($result)) { if (array_key_exists($row["AC_ID5"], $receive_array)) { $receive_array[$row["AC_ID5"]] -= $row["SUM(AMOUNT)"]; } } beginPrettyTable("1", "Schedule of Advance as on " . get_today_hrd_string()); if (isset($receive_array)) { printRow(array("Code", "Employer's name", "Amount")); foreach ($receive_array as $key => $value) { if ($value != 0) { printRow(array("{$key}", get_ac5_desc_of($key), 0 - $value), "something"); } $sum += 0 - $value; } printRow(array("", "Sum", $sum)); } else { printRow(array("No Advance-money at anybody!"), ""); } endPrettyTable(); endDocument();
} # calculate received money by Employees $result = mysql_query("select SUM(AMOUNT),AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='C' GROUP BY AC_ID5 order by PARTY", $db); checkMySQLError(); $receive_array = array(); while ($row = mysql_fetch_array($result)) { $receive_array[$row["AC_ID5"]] = $row["SUM(AMOUNT)"]; } # calculate paid_back money $result = mysql_query("select SUM(AMOUNT),PARTY, AC_ID5 from TRANS WHERE AC_ID3=30 AND DR_CR='D' GROUP BY PARTY order by PARTY", $db); checkMySQLError(); while ($row = mysql_fetch_array($result)) { if (array_key_exists($row["AC_ID5"], $receive_array)) { $receive_array[$row["AC_ID5"]] -= $row["SUM(AMOUNT)"]; } } beginPrettyTable("1", "Schedule of Advance as on " . get_today_hrd_string()); if (isset($receive_array)) { printRow(array("Code", "Employer's name", "Amount")); foreach ($receive_array as $key => $value) { if ($value != 0) { printRow(array("{$key}", get_ac5_desc_of($key), 0 - $value), "fluct"); } $sum += 0 - $value; } printRow(array("", "Sum", $sum)); } else { printRow(array("No Advance-money at anybody!"), ""); } endPrettyTable(); endDocument();