Hi!
Im creating individual excel file base on the duedate and client name of a reservation and sending it automatically on that date.but im having a trouble dispalying the SUM/ Grandtotal of each excel summary that i created. the grandtotal inside my while loop is also incrementing. i dont now what i am doing wrong.
Example
for today i have 4 Client that has a duedate today. and the script automatically generated the excel file summary of each client.
Client 1. 7 STONES
Client 2. Your Travel Planner
Client 3. ZOEMIE
And the Last Zulu Plaza . Notice that this one has no problem dispalying trhe Grandtotal
You can see that from the First excel file to the 3rd it has a duplicate Grandtotal
This is the Script that i used creating the excel files.
<?php
error_reporting(E_ALL);
include '../includes/pdo_config.php';
include '../includes/phpexcel_config.php';
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
date_default_timezone_set('Asia/Manila');
/** PHPExcel_IOFactory */
require_once dirname(__FILE__) . '/Classes/PHPExcel/IOFactory.php';
$today = date('Y-m-d');
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load("templates/Billing.xls");
try {
$getname=$con->prepare("SELECT msicph_globalsouthwest.accounts_info.name,
msicph_globalsouthwest.accounts_info.email
FROM msicph_globalsouthwest.accounts_info
WHERE msicph_globalsouthwest.accounts_info.name
IN ( SELECT msicph_southwest.reservations.resfor
FROM msicph_southwest.reservations
WHERE msicph_southwest.reservations.`duedate` = DATE_SUB(CURDATE(), INTERVAL - 3 DAY))");
$getname->execute();
$i = 0;
ob_start();
while ($dataname = $getname->fetch(PDO::FETCH_ASSOC)) {
$resfor=$dataname['name'];
$email=$dataname['email'];
$stmts = $con->prepare("SELECT * FROM reservations WHERE resfor='$resfor' and
`duedate` = DATE_SUB(CURDATE(), INTERVAL - 3 DAY)");
$stmts->execute();
$objPHPExcel->getActiveSheet()->setCellValue('I1', PHPExcel_Shared_Date::PHPToExcel(time()));
$baseRow = 5;
$run = 0; …Hi
Im having a hardtime making my query work the way it should be.i'm getting wrong output. basically what im trying to do is a simple user statistic that will show the user inputed data and user processed data base on the date range the user selected.
heres the screenshots for better visualization
and the query for that is.
first Get all the user from the user table
Select Name from user GROUP BY Name ORDER BY Name ASC
then i will loop inside the reservations table for the matching username base on the date range selected
select
SDate,
FoName,
COUNT( FoName ) AS 'opentrans'
From reservations
where SDate BETWEEN '" . $from . "' AND '" . $to. "'
AND FoName='$ngaran'
GROUP BY FoName ORDER BY FoName ASC
after getting all the username available on that date range. i will loop inside table trans_logs to get all the proceesed/served transactions on that date range
Select username,status,
SUM( IF( status = 'Served', 1, 0 ) ) Served
from trans_logs
where datetime
BETWEEN '" . $from . " 00:00' AND '" . $to. " 23:59'
and username='$ngaran' group by username order by username
I know that is not a great approach. but its the only closest thing in getting what i want. but i also tried using diffrent method the problem is that while im getting the correct result that i want i cant find a way to make the presentation of the …
Hi everyone
i need some help down here. i am trying to connect multiple db and at the same time i want to sum the value of the column. what i have right now is this
SELECT SUM(total) as branch1sales FROM icm.sales
UNION
SELECT sum(total) as branch2sales FROM hism.sales
its computing correctly but the problem is the branch2 alias is being invoke. what am i doing wrong? see attached image for the output
thanks