Need some Array help

elentz · November 9, 2007

First of all I am not a programmer, just someone who knows enough to be dangerous. Smile I have a script that was made by others that I need to extract some information from the array and I don't know how to do it. So here is the code I have provided all the code from the page I believe where the array is created.

<?php
require_once('include/PDF_modules/quotes/fpdf/pdf.php');
require_once('include/PDF_modules/quotes/fpdf/pdfconfig.php');
require_once('modules/Quotes/Quotes.php');
require_once('include/database/PearDatabase.php');

global $adb,$app_strings;

$sql="select currency_symbol from vtiger_currency_info";
$result = $adb->query($sql);
$currency_symbol = $adb->query_result($result,0,'currency_symbol');

// would you like and end page?  1 for yes 0 for no
$endpage="1";

$focus = new Quotes();
$focus->retrieve_entity_info($_REQUEST['record'],"Quotes");
$account_name = getAccountName($focus->column_fields[account_id]);

if($focus->column_fields["hdnTaxType"] == "individual") {
        $product_taxes = 'true';
} else {
        $product_taxes = 'false';
}

// **************** BEGIN POPULATE DATA ********************
$account_id = $focus->column_fields[account_id];
$quote_id=$_REQUEST['record'];

// Quote Information
$valid_till = $focus->column_fields["validtill"];
$valid_till = getDisplayDate($valid_till);
$bill_street = $focus->column_fields["bill_street"];
$bill_city = $focus->column_fields["bill_city"];
$bill_state = $focus->column_fields["bill_state"];
$bill_code = $focus->column_fields["bill_code"];
$bill_country = $focus->column_fields["bill_country"];
$contact_name =getContactName($focus->column_fields["contact_id"]);

$ship_street = $focus->column_fields["ship_street"];
$ship_city = $focus->column_fields["ship_city"];
$ship_state = $focus->column_fields["ship_state"];
$ship_code = $focus->column_fields["ship_code"];
$ship_country = $focus->column_fields["ship_country"];

$conditions = from_html($focus->column_fields["terms_conditions"]);
$description = from_html($focus->column_fields["description"]);
$status = $focus->column_fields["quotestage"];

// Company information
$add_query = "select * from vtiger_organizationdetails";
$result = $adb->query($add_query);
$num_rows = $adb->num_rows($result);

if($num_rows > 0)
{
        $org_name = $adb->query_result($result,0,"organizationname");
        $org_address = $adb->query_result($result,0,"address");
        $org_city = $adb->query_result($result,0,"city");
        $org_state = $adb->query_result($result,0,"state");
        $org_country = $adb->query_result($result,0,"country");
        $org_code = $adb->query_result($result,0,"code");
        $org_phone = $adb->query_result($result,0,"phone");
        $org_fax = $adb->query_result($result,0,"fax");
        $org_website = $adb->query_result($result,0,"website");

        $logo_name = $adb->query_result($result,0,"logoname");
}


//Population of Product Details - Starts

//we can cut and paste the following lines in a file and include that file here is enough. For that we have to put a new common file. we will do this later
//NOTE : Removed currency symbols and added with Grand Total text. it is enough to show the currency symbol in one place

//we can also get the NetTotal, Final Discount Amount/Percent, Adjustment and GrandTotal from the array $associated_products[1]['final_details']

//getting the Net Total
$price_subtotal = number_format($focus->column_fields["hdnSubTotal"],2,'.',',');

//Final discount amount/percentage
$discount_amount = $focus->column_fields["hdnDiscountAmount"];
$discount_percent = $focus->column_fields["hdnDiscountPercent"];

if($discount_amount != "")
        $price_discount = number_format($discount_amount,2,'.',',');
else if($discount_percent != "")
{
//This will be displayed near Discount label - used in include/fpdf/templates/body.php
        $final_price_discount_percent = "(".number_format($discount_percent,2,'.',',')." %)";
        $price_discount = number_format((($discount_percent*$focus->column_fields["hdnSubTotal"])/100),2,'.',',');
}
else
        $price_discount = "0.00";

//Adjustment
$price_adjustment = number_format($focus->column_fields["txtAdjustment"],2,'.',',');
//Grand Total
$price_total = number_format($focus->column_fields["hdnGrandTotal"],2,'.',',');


//get the Associated Products for this Invoice
$focus->id = $focus->column_fields["record_id"];
$associated_products = getAssociatedProducts("Quotes",$focus);
$num_products = count($associated_products);

//This $final_details array will contain the final total, discount, Group Tax, S&H charge, S&H taxes and adjustment
$final_details = $associated_products[1]['final_details'];

//To calculate the group tax amount
if($final_details['taxtype'] == 'group')
{
        $group_tax_total = $final_details['tax_totalamount'];
        $price_salestax = number_format($group_tax_total,2,'.',',');

        $group_total_tax_percent = '6.00';
        $group_tax_details = $final_details['taxes'];
        for($i=0;$i<count($group_tax_details);$i++)
        {
                $group_total_tax_percent = $group_total_tax_percent+$group_tax_details[$i]['percentage'];
        }
}

//S&H amount
$sh_amount = $final_details['shipping_handling_charge'];
$price_shipping = number_format($sh_amount,2,'.',',');

//S&H taxes
$sh_tax_details = $final_details['sh_taxes'];
$sh_tax_percent = '0.00';
for($i=0;$i<count($sh_tax_details);$i++)
{
        $sh_tax_percent = $sh_tax_percent + $sh_tax_details[$i]['percentage'];
}
$sh_tax_amount = $final_details['shtax_totalamount'];
$price_shipping_tax = number_format($sh_tax_amount,2,'.',',');


//This is to get all product details as row basis
for($i=1,$j=$i-1;$i<=$num_products;$i++,$j++)
{
        $product_name[$i] = $associated_products[$i]['productName'.$i]."\n".$associated_products[$i]['comment'.$i];
         $prod_description[$i]=$prod_description[$i]."\n".$associated_products[$i]['comment'.$i];
        //$prod_description[$i] = $associated_products[$i]['productDescription'.$i];
        $product_id[$i] = $associated_products[$i]['hdnProductId'.$i];
        $qty[$i] = $associated_products[$i]['qty'.$i];
        $unit_price[$i] = number_format($associated_products[$i]['unitPrice'.$i],2,'.',',');
        $list_price[$i] = number_format($associated_products[$i]['listPrice'.$i],2,'.',',');
        $list_pricet[$i] = $associated_products[$i]['listPrice'.$i];
        $discount_total[$i] = $associated_products[$i]['discountTotal'.$i];
        //added for 5.0.3 pdf changes
        $product_code[$i] = $associated_products[$i]['hdnProductcode'.$i];
       
        $taxable_total = $qty[$i]*$list_pricet[$i]-$discount_total[$i];
         $producttotal = $taxable_total;
        $total_taxes = '0.00';
        if($focus->column_fields["hdnTaxType"] == "individual")
        {
                $total_tax_percent = '6.00';
                //This loop is to get all tax percentage and then calculate the total of all taxes
                for($tax_count=0;$tax_count<count($associated_products[$i]['taxes']);$tax_count++)
                {
                        $tax_percent = $associated_products[$i]['taxes'][$tax_count]['percentage'];
                        $total_tax_percent = $total_tax_percent+$tax_percent;
                        $tax_amount = (($taxable_total*$tax_percent)/100);
                        $total_taxes = $total_taxes+$tax_amount;
                }
                $producttotal = $taxable_total+$total_taxes;
                $product_line[$j]["Tax"] = number_format($total_taxes,2,'.',',')."\n ($total_tax_percent %) ";
        }
        $prod_total[$i] = number_format($producttotal,2,'.',',');

        $product_line[$j]["Product Code"] = $product_code[$i];
        $product_line[$j]["Product Name"] = from_html($product_name[$i]);
        $product_line[$j]["Qty"] = $qty[$i];
        $product_line[$j]["Price"] = $list_price[$i];
        $product_line[$j]["Discount"] = $discount_total[$i];
        $product_line[$j]["Total"] = $prod_total[$i];
}
//echo '<pre>Product Details ==>';print_r($product_line);echo '</pre>';
echo '<pre>';print_r($associated_products);echo '</pre>';


//Population of Product Details - Ends


// ************************ END POPULATE DATA ***************************8

$page_num='1';
$pdf = new PDF( 'P', 'mm', 'A4' );
$pdf->Open();

$num_pages=ceil(($num_products/$products_per_page));


$current_product=0;
for($l=0;$l<$num_pages;$l++)
{
        $line=array();
        if($num_pages == $page_num)
                $lastpage=1;

        while($current_product != $page_num*$products_per_page)
        {
                $line[]=$product_line[$current_product];
                $current_product++;
        }

        $pdf->AddPage();
        include("pdf_templates/header.php");
        include("pdf_templates/body.php");

//if bottom > 145 then we skip the Description and T&C in every page and display only in lastpage
//if you want to display the description and T&C in each page then set the display_desc_tc='true' and bottom <= 145 in pdfconfig.php
        if($display_desc_tc == 'true')
        if($bottom <= 145)
        {
                include("pdf_templates/footer.php");
        }

        $page_num++;

        if (($endpage) && ($lastpage))
        {
                $pdf->AddPage();
                include("pdf_templates/header.php");
                include("pdf_templates/lastpage/body.php");
                include("pdf_templates/lastpage/footer.php");
        }
}

//added file name to make it work in IE, also forces the download giving the user the option to save
$pdf->Output('Proposal # '.$quote_id.' For '.$account_name.'.pdf','D');
exit();
?>

Here is a representation of what the array will output. I found a line commented out that would show me what the array has in it.

If someone could show me how to get a total or sum of the "totalafterdiscount" so I can use it to get a tax amount I would be very appreciative!

Thanks alot

GingerRobot · November 9, 2007

Well, judging from the output of the array at the bottom, something like this should work:

<?php
$total = 0;
for($x=1;$x<=count($array);$x++){
$total += $array[$x]['totalAfterDiscount'.$x];
}
echo $total;
?>

Where $array is the name of the array we are wroking with. The code was hugely confusing, so i didn't see what the name of the variable actually was. Also, the use of the number on the end of the array keys (e.g. totalAfterDiscount1) rather defeats the purpose of an array. Anyways, it's not your code, so i don't suppose you care.

Next time, use

 tags(without the spaces)

elentz · November 9, 2007

Thanks Ben for the help I'll see what it does tonight. I looked for something to enclose the code when I posted. I'll try to remember that. I wished that code weren't so confusing, but as you said it isn't mine.

I'll let you know if I get it to work

Thanks again

Ed

elentz · November 10, 2007

Ben,

Using what you gave me I tried all the array names I could find with no luck. Any other ideas?

Thanks

elentz · November 10, 2007

WEll, with some fiddling I actually found the two array fields that I want. I need to get a sum of these fields. they are $taxable_total and $total_taxes. These fields are created for each product item in the array. I have tried to figure out how to use Array_sum with no success. When all is done I need to assign a string to this sum so I can pass it to fpdf to generate a pdf. I have that working so I just need to get that variable.

Thanks!

Sign In

Need some Array help

Recommended Posts

elentz

Link to comment

Share on other sites

GingerRobot

Link to comment

Share on other sites

elentz

Link to comment

Share on other sites

elentz

Link to comment

Share on other sites

elentz

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information