error: Call to Undefined Function

**newphpcoder** · 04-24-2012 06:56 PM

Hi..

I have a function for convert to dozen.

here is my code:

PHP Code:


<?php

    error_reporting(0);

  date_default_timezone_set("Asia/Singapore"); //set the time zone  

$con = mysql_connect('localhost', 'root','');



if (!$con) {

    echo 'failed';

    die();

}



mysql_select_db("mes", $con);

$Date_Shelve =date('Y-m-d H:i:s');  





?>

<html>

<head>

<title>Job Order</title> 

<link rel="stylesheet" type="text/css" href="kanban.css" />

</head>

<body>



<div id="ddcolortabs">

<ul>

<li id="current"> <a href="SalesOrder.php" title="Sales Order"><span>Order Management</span></a></li>

<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>

<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>WIP Report</span></a></li>

<li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li>

<li><a href="ReceivingMaterials.php" title="WMS RM"><span>WMS RM</span></a></li>  

</ul>

</div>

<div id="ddcolortabs1">

<ul>

<li><a href="SalesOrder.php" title="Sales Order"><span>Sales Order</span></a></li>

<li id="current"><a href="JobOrder.php" title="Job Order"><span>Job Order</span></a></li>    

</ul>

</div> 



<div id="SR_date">



<input type="hidden" name="Date_Shelve" id="Date_Shelve" value="<?php echo $Date_Shelve; ?>" size="16" readonly="readonly" style="border: none;">    

</div>





<?php

//----approve button-----//

$Approved = isset($_POST['priority']);

if ($Approved)

{

    $PO_No = $_POST['PO_No'];  

    $ETD = $_POST['ETD'];

    $SKUCode = $_POST['SKUCode'];

    $Description = $_POST['Description'];

    $POReq = $_POST['POReq'];   

    $priority = $_POST['priority'];

   

     $sql = "SELECT SKUCode, Materials, Comp, Qty 

     FROM bom  WHERE SKUCode = '$SKUCode'";

     $res = mysql_query($sql, $con);

     

     $row = mysql_fetch_assoc($res);

     $Materials = $row['Materials'];

     $Qty = $row['Qty'];

     $Comp = $row['Comp'];

     

     $ReqQty = $Qty * $POReq;

     

$sql = "UPDATE bom SET ReqQty = '$ReqQty' WHERE SKUCode = '$SKUCode' AND Materials = '$Materials'";

$resReqQty = mysql_query($sql, $con);





    $sql  =  "SELECT SUM(WEIGHING) AS WEIGHING_TOTAL, "; 

    $sql .=  "SUM(COMPOUNDING) AS COMPOUNDING_TOTAL, ";

    $sql .=  "SUM(EXTRUSION) AS EXTRUSION_TOTAL, ";                                                        

    $sql .=  "SUM(FORMING) AS FORMING_TOTAL, ";

    $sql .=  "SUM(DIPPING) AS DIPPING_TOTAL, ";

    $sql .=  "SUM(MOULDING) AS MOULDING_TOTAL ";

    $sql .=  "FROM MES_REPORT_OPEN WHERE SUBSTRING(LOT_CODE, 9) = '$Comp'";

    

    

    $result = mysql_query($sql, $con);

    

    $weighingTotal = mysql_result($result, 0, "WEIGHING_TOTAL");

    $weighingTotal = convertToDozen($weighingTotal, $Comp);

    $weighingAccum = $weighingAccum + $weighingTotal;

    $compoundingTotal = mysql_result($result, 0, "COMPOUNDING_TOTAL");

    $compoundingTotal = convertToDozen($compoundingTotal, $Comp);

    $compoundingAccum = $compoundingAccum + $compoundingTotal;

    

    $extrusionTotal = mysql_result($result, 0, "EXTRUSION_TOTAL");

    $extrusionTotal = convertToDozen($extrusionTotal, $Comp);

    $extrusionAccum = $extrusionAccum + $extrusionTotal; 

       

    $formingTotal = mysql_result($result, 0, "FORMING_TOTAL");

    $formingTotal = convertToDozen($formingTotal, $Comp);

    $formingAccum = $formingAccum = $formingTotal;

    

    $dippingTotal = mysql_result($result, 0, "DIPPING_TOTAL");

    $dippingTotal = convertToDozen($dippingTotal, $Comp);

    $dippingAccum = $dippingAccum + $dippingTotal;



    $virtualY = $weighingTotal + $compoundingTotal + $extrusionTotal + $formingTotal;

    

    $totalY = $dippingTotal + $virtualY;

    

    function convertToDozen ($total,  $cmpdType) {

     switch ($cmpdType) {

        case "P28" :

            $convTotal = (($total * 1000) / 22.00) / 12;

        break;

        case "P30" :

            $convTotal = (($total * 1000) / 25.10) / 12;

        break;

        case "P32" :

            $convTotal = (($total * 1000) / 22.50) / 12;

        break;

        case "P33" :

            $convTotal = (($total * 1000) / 25.00) / 12;

        break;

        case "P35" :

            $convTotal = (($total * 1000) / 25.25) / 12;

        break;

        case "P35M" :

            $convTotal = (($total * 1000) / 22.60) / 12;

        break;

        case "P35W" :

            $convTotal = (($total * 1000) / 22.50) / 12;

        break;

        case "P38" :

            $convTotal = (($total * 1000) / 26.70) / 12;

        break;

        case "P41" :

            $convTotal = (($total * 1000) / 24.80) / 12;

        break;

        case "P42" :

            $convTotal = (($total * 1000) / 18.90) / 12;

        break;

        case "P43" :

            $convTotal = (($total * 1000) / 25.00) / 12;

        break;

        case "P46" :

            $convTotal = (($total * 1000) / 27.00) / 12;

        break;

        case "P47" :

            $convTotal = (($total * 1000) / 27.60) / 12;

        break;

    }

     return round($convTotal, 2);        

}

}

else{

    

}

 





$sql = "SELECT jo_number, ETD, PO_No, SKUCode, Description, POQty, Priority

FROM job_order ORDER BY jo_number, ETD";

$res = mysql_query($sql,$con);

?>

<div id="kanban_table" style="overflow:auto; height:215px;"> 

<table>

<th> JO No.</th>

<th> ETD </th>

<th> PO No. </th>

<th> SKU Code </th>

<th> Description </th>

<th> PO Req </th>

<th> Priority</th>

<?php

$sql = "SELECT ETD, PO_No, SKUCode, Description, POReq 

FROM sales_order  WHERE NOT EXISTS (SELECT PO_No FROM job_order WHERE job_order.PO_No = sales_order.PO_No) ORDER BY ETD, PO_No ";

$res_so = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_so)){ 

echo "<form name='joborder_form' action='' method='post'>";   

$PO_No = $row['PO_No'];    

echo "<tr>

<td><input type='text' value='' style='border:none;' size='10'></td>

<td><input type='text' name='ETD' id='ETD' value='$row[ETD]' style='border:none;' size='10'></td> 

<td><input type='text' name='PO_No' id='PO_No' value='$row[PO_No]' style='border:none;' size='30'></td>

<td><input type='text' name='SKUCode' id='SKUCode' value='$row[SKUCode]' style='border:none;' size='15'></td>

<td><input type='text' name='Description' id='Description' value='$row[Description]' style='border:none;' size='35'></td>

<td><input type='text' name='POReq' id='POReq' value='$row[POReq]' style='border:none;' size='10'></td> 

<td><input type='submit' name='priority' value='Approved' id='priority'></td>

</tr>";

echo "</form>";

}

echo "</table>";

echo "</div>";    









echo "<div style='overflow:auto; height:215px;'>";

echo "<table>";

while($row_job = mysql_fetch_assoc($res)){

    echo "<tr>

    <td><input type='text' name='JO_No_' id='JO_No_' value='$row_job[jo_number]' style='border:none;width:auto;' size='10'></td>

    <td><input type='text' name='ETD_' id='ETD_' value='$row_job[ETD]' style='border:none;width:auto;' size='10'></td> 

    <td><input type='text' name='PO_No_' id='PO_No_' value='$row_job[PO_No]' style='border:none;' size='30'></td>

    <td><input type='text' name='SKUCode_' id='SKUCode_' value='$row_job[SKUCode]' style='border:none;' size='15'></td>

    <td><input type='text' name='Description_' id='Description_' value='$row_job[Description]' style='border:none;' size='35'></td>

    <td><input type='text' name='POReq_' id='POReq_' value='$row_job[POQty]' style='border:none;width:auto;' size='10'></td> 

    <td><input type='text' name='priority_' value='$row_job[Priority]' id='priority_' style='border:none;width:auto;' size='10'></td> 

    </tr>" ;

}

echo "</table>";

echo "</div>"  

?>



</body>

</html>

but I when I echo this:

PHP Code:


 echo $weighingTotal;

No result, then when I debug my code I got an error: Call to undefined function.

I can’t configured out where in my code was wrong?

Any help is highly appreciated.

Thank you

**NogDog** · 04-24-2012 09:35 PM

Move the function definition outside if the if() block. It will then get defined before any code actually gets processed, whereas if it is within a conditional block, then it does not get defined until that if() condition is triggered and the function definition code is actually executed. (As long as the function definition is not within any such conditional block, it will get defined first, regardless of its position in the script.)

**newphpcoder** · 04-25-2012 03:06 AM

Thank you

Thread: error: Call to Undefined Function

Thread Tools

Display

error: Call to Undefined Function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions