|
PHP - Moved: Creat A Jasper Report File Using Flash Designer
This topic has been moved to Miscellaneous.
http://www.phpfreaks.com/forums/index.php?topic=348555.0 Similar TutorialsThis topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=314049.0 This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=314453.0 I need to email this report but I don't know where to start
I have included the report code.
<html>
<head>
<title>Customer Load Report</title>
</head>
<body>
<h1>Customer Load Report</h1>
<?php
$custid=$_POST["Cust_ID"];
$connect =odbc_connect("removed");
if(!$connect) {
exit("Connection Failed: " . $connect);
}
$sql="SELECT m1_DC.dbo.organizationlocations.cmlName
,m1_DC.dbo.SalesOrders.OMPSHIPPINGMETHODID
,m1_DC.dbo.SalesOrders.UOMPTRUCKNUMBER
,m1_DC.dbo.SalesOrders.ompCustomerPO
,m1_DC.dbo.SalesOrders.UOMPTOTALBOXCOUNT
,m1_DC.dbo.SalesOrders.UOMPVOLUMETOTAL
,m1_DC.dbo.organizationlocations.CMLADDRESSLINE1
,m1_DC.dbo.organizationlocations.CMLADDRESSLINE2
,m1_DC.dbo.organizationlocations.CMLCITY
,m1_DC.dbo.organizationlocations.CMLSTATE
,m1_DC.dbo.organizationlocations.CMLPOSTCODE
,m1_DC.dbo.SalesOrders.OMPREQUESTEDSHIPDATE
,m1_DC.dbo.SalesOrders.ompSalesOrderID
,convert(varchar(10),m1_DC.dbo.SalesOrders.ompRequestedShipDate,110) as ShipDate
FROM m1_DC.dbo.SalesOrders
LEFT OUTER JOIN m1_DC.dbo.organizationlocations ON ompshiporganizationid = cmlorganizationid
AND ompshiplocationid = cmllocationid
WHERE
m1_DC.dbo.SalesOrders.ompCustomerOrganizationID='$custid' and (ompOrderDate>=CONVERT(VARCHAR(10),DATEADD(day, -7, getdate()),110) or
convert(varchar(10),m1_DC.dbo.SalesOrders.ompRequestedShipDate,110) >=getdate())";
$result =odbc_exec($connect,$sql);
if(!$result){
exit("Error in SQL");
}
$data= '';
while (odbc_fetch_row($result)) {
$cmlName=odbc_result($result,"cmlName");
$ompCustomerPO=odbc_result($result,"ompCustomerPO");
$UOMPTOTALBOXCOUNT=odbc_result($result,"UOMPTOTALBOXCOUNT");
$UOMPVOLUMETOTAL=odbc_result($result,"UOMPVOLUMETOTAL");
$CMLADDRESSLINE1=odbc_result($result,"CMLADDRESSLINE1");
$CMLADDRESSLINE2=odbc_result($result,"CMLADDRESSLINE2");
$CMLCITY=odbc_result($result,"CMLCITY");
$CMLSTATE=odbc_result($result,"CMLSTATE");
$CMLPOSTCODE=odbc_result($result,"CMLPOSTCODE");
$ompSalesOrderID=odbc_result($result,"ompSalesOrderID");
$ompRequestedShipDate=odbc_result($result,"ShipDate");
$data .= "<td style='text-align:left' > $ompCustomerPO</td>";
$data .= "<td style='text-align:left'> $UOMPTOTALBOXCOUNT</td>";
$data .= "<td style='text-align:left'> $UOMPVOLUMETOTAL</td>";
$data .= "<td style='text-align:left'> $CMLADDRESSLINE1</td>";
$data .= "<td style='text-align:left'> $CMLADDRESSLINE2</td>";
$data .= "<td style='text-align:left'> $CMLCITY</td>";
$data .= "<td style='text-align:left'> $CMLSTATE</td>";
$data .= "<td style='text-align:left'> $CMLPOSTCODE</td>";
$data .= "<td style='text-align:left'> $ompSalesOrderID</td>";
$data .= "<td style='text-align:left'> $ompRequestedShipDate</td></tr>";
}
echo "<table><tr>";
echo "<th>PO</th>";
echo "<th>Box_count</th>";
echo "<th>Cubes</th>";
echo "<th>ADDRESSLINE</th>";
echo "<th>ADDRESS2</th>";
echo "<th>CITY</th>";
echo "<th>STATE</th>";
echo "<th>ZIP</th>";
echo "<th>Order_ID</th>";
echo "<th>Ship Date</th></tr>";
echo $data;
odbc_close($connect);
?>
</body>
</html>
This topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=320884.0 This topic has been moved to Other. http://www.phpfreaks.com/forums/index.php?topic=307175.0 This topic has been moved to Ajax Help. http://www.phpfreaks.com/forums/index.php?topic=326310.0 I have got a flash file that is stored in the database. So I fetch it and put it in a variable then put the variable in the flash embed code where the src is but the flash comes up blank. $file = "SELECT * FROM table WHERE column='$name'"; $file2 = mysql_query($sqlfile); $file3 = @mysql_fetch_assoc($file2); $file4 = $file3['gamefile']; //skip some code to html embed section <object width='550' height='400'> <param name='movie' value='valuename'> <embed src='$file4' width='550' height='400'> </embed> </object> then the page comes up with a white box which when you hover over it says 'file not loaded'. This topic has been moved to Other. http://www.phpfreaks.com/forums/index.php?topic=347753.0 This topic has been moved to JavaScript Help. http://www.phpfreaks.com/forums/index.php?topic=359179.0 This topic has been moved to Apache HTTP Server. http://www.phpfreaks.com/forums/index.php?topic=349296.0 Hi all, I have a few questions and like some input on how best to approach this, I have a form in which customers can order different size online ads, the form has fields such as customer name, sales rep name, date needed by etc, my issue is I want to be able to run a report on how many different size ads I'm building in a day or month, would using MySQL be my solution to this? My PHP form right now gathers the information entered and sends me an email. Good day, How can I create a pdf report on my web page pulling out data from my database. I have never done this before I just need an idea. Hi to all gurus, Here is a small program in flash which calls values from PHP and displays them correctly.
path = "http://localhost/xampp/nwjv/php/"; //declare path to php files
lvOut = new LoadVars(); //create lv object sending variables OUT to php
lvIn = new LoadVars(); //create lv object receiving variables IN from php
lvIn.onLoad = function (success) {
if(success)
{
//PHP variable value to textbox
InVal = lvIn.returnVal;
InTxt = lvIn.retVal;
output.text = InVal;
output1.text = InTxt;
/* output1.text = "No Value";
if(InTxt == 'lo' )
{
output1.text = "Low Value";
}
if(InTxt == 'hi')
{
output1.text = "High Value";
}
*/
}else{
//...or notify of failure
output.text = "fail";
}
}
myBtn.onRelease = function(){
//assign user-input value to lv property called years
lvOut.years = years.text;
//send to a blank window
// lvOut.send(path + "dogyears_new1.php",lvIn,"GET");
lvOut.sendAndLoad(path + "dogyears_new1.php",lvIn,"GET");
};
Hi all, For a logging tool I need to make some automated reports. On 1 page it needs to give for 4 clients the amount of calls per month for the last 12 months. Also it needs to give the amount of calls for the employees per month for the last 12 months. I was hoping you could help me with a better solution than seperate queries. Gr Ryflex ok. this may make now sense at all, I will try to explain as best as I can. anyways, what I need is for a mysql query to run that will pull all data from table payment between certain days. Then all the rows will show, but I want only one row with each cart_id(there will be multiple) to show. After it does that, in a new column on a table, all the payment types with the amount will show with a slash between each one. I want all of this in a table generated from a php loop. maybe a visual represenation will be better. I hope the picture I attached makes a bit more sense. Hi guys, this is very urgent. Can anyone help me out..... I want to generate reports using php and MySQL. I have one table which includes customer_id, full_name, name_with_initials, address, contact_number and gender fields. I want to print the details of all the records of the table. It should be good if results will come on a PDF format. Thanks, Hi All, I am trying to generate a PDF report using the below code. the report is being generated perfectly. The problem that I face is that, while printing the report the browser disregards the "IF" condition that I have given in the code. Explanation : ----------------- It prints all the data in the MySQL database wherein I wanted the data to be printed only on a certain condition. How do I achieve this? Quote <?php mysql_connect('localhost','user','pass'); mysql_select_db('vaccine'); $array = mysql_query("SELECT cattle_n FROM vactbl"); $num_rows = mysql_num_rows($array); $array = mysql_query("SELECT * FROM vactbl"); $num_rows = mysql_num_rows($array); while($info = mysql_fetch_array( $array )) { $mas_date = $info['masdt']; $mas_time = strtotime($mas_date); $two_week = strtotime("+2 week"); $rpt_date = abs($two_week - $mas_time); if ($rpt_date >= 7776000) { require('mysql_table.php'); class PDF extends PDF_MySQL_Table { function Header() { //Title $this->SetFont('Arial','B',40); $this->Cell(0,6,'Cattle List',0,1,'C'); $this->Ln(10); //Ensure table header is output parent::Header(); } } //Connect to database $pdf=new PDF(); $pdf->AddPage(); //First table: put all columns automatically //$pdf->Table('select * from cattle_det order by no'); //$pdf->AddPage(); //Second table: specify 3 columns $pdf->AddCol('cattle_n',20,'Cattle','C'); $pdf->AddCol('masdt',40,'Mastitis Date', 'C'); $pdf->AddCol('fmdt',40,'FM Date','C'); $pdf->AddCol('onedt',40,'Vaccine1 Date','C'); $pdf->AddCol('twodt',40,'Vaccine2 Date','C'); $prop=array('HeaderColor'=>array(255,150,100), 'color1'=>array(210,245,255), 'color2'=>array(255,255,210), 'padding'=>2); $pdf->Table('select cattle_n, masdt, fmdt, onedt, twodt from vactbl order by cattle_n limit 0,10',$prop); $pdf->Output(); } else {} } ?> Hi, I have to build some reports based on mysql queries. Nothing fancy, just text, columns... There are a lot of paid softwares but I can't (and don't want to) spend any $$ right now... So, considering that I want very simple reports almost like a table with heading and subtotals, I should write it myself. But I don't know how (still...). I'm looking for tips, tutorials, ebooks... anything that explains how to make a very simply report. Regards, Pedro. Hello, I have a database with the following tables: students groups exams examDay relation master detail ======= ===== ===== ======= ====== ====== ===== idStudent idGroup idExam idExDay idRelation idMaster idDetail idGroup groupName examName exDate idGroup idGroup idMaster studName idExDay idRelation idExam idExam idStudent coursesAtt idExDay I am trying to make a report from the Master and Detail tables that will have the table header like this: Group | Examination Date | Student Name | Exam1 | Exam2| .... | Exam n in which Exam1, Exam2,... are the exams names and they had to take the values from coursesAtt column. Is this possible? I could make a view (doing joins and group by) by the results will be displayed on row. That's why I ask for your help. Thanks hi, i looking for a design report like crystal report or active reports but for php the objective is creat a report using mysql data and save the template and load that report in a pdf file for print or save any one know something like that? i already use classes like class.ezpdf.php but i spend many hours creating complex reports, all is created using a text editor.. thanks for your help |
|||||||