root/trunk/phpbms/modules/bms/receipts_aritem_ajax.php

<?php

        include("../../include/session.php");

        class receiptARItemAjax{

                function receiptARItemAjax($db){

                        $this->db = $db;

                }//end method


                function getItemsByClient($clientid){

                        $querystatement = "
                                SELECT
                                        `aritems`.`id`,
                                        IF(`aritems`.`type` = 'invoice', `invoices`.`id`, '\'\'') AS `invoiceid`,
                                        `aritems`.`uuid`,
                                        `aritems`.`relatedid`,
                                        `aritems`.`itemdate`,
                                        `aritems`.`type`,
                                        `aritems`.`amount`,
                                        `aritems`.`paid`
                                FROM
                                        `aritems` LEFT JOIN `invoices` ON `aritems`.`relatedid`=`invoices`.`uuid`
                                WHERE
                                        `aritems`.`status` = 'open'
                                        AND `aritems`.`clientid` = '".mysql_real_escape_string($clientid)."'
                                        AND `aritems`.`posted` = '1'
                                ORDER BY
                                        `aritems`.`itemdate`
                        ";

                        return $this->db->query($querystatement);

                }//end method


                function getItemByID($aritemid){

                        $querystatement = "
                                SELECT
                                        `aritems`.`id`,
                                        IF(`aritems`.`type` = 'invoice', `invoices`.`id`, '\'\'') AS `invoiceid`,
                                        `aritems`.`uuid`,
                                        `aritems`.`relatedid`,
                                        `aritems`.`itemdate`,
                                        `aritems`.`type`,
                                        `aritems`.`amount`,
                                        `aritems`.`paid`
                                FROM
                                        `aritems` LEFT JOIN `invoices` ON `aritems`.`relatedid`=`invoices`.`uuid`
                                WHERE
                                        `aritems`.`uuid` = '".mysql_real_escape_string($aritemid)."'
                                ORDER BY
                                        `aritems`.`itemdate`";

                        return $this->db->query($querystatement);

                }//end method


                function outputItemsJSON($queryresult){

                        $jsonOutput = "{\n";
                        $count = 1;

                        while($therecord = $this->db->fetchArray($queryresult)){

                                $jsonOutput .= "\titem".$count.": {\n";

                                foreach($therecord as $key=>$value){

                                        $jsonOutput .= "\t\t".$key.":";

                                        switch($key){

                                                case "id":
                                                case "amount":
                                                case "paid":
                                                case "invoiceid":
                                                        $jsonOutput .= $value.",\n";
                                                        break;

                                                default:
                                                        $jsonOutput .= "'".$value."',\n";
                                                        break;

                                        }//endswitch

                                }//endforeach

                                $jsonOutput = substr($jsonOutput, 0, strlen($jsonOutput)-2);

                                $jsonOutput .= "\n\t},\n";

                                $count++;

                        }//endwhile

                        if(strlen($jsonOutput) > 2)
                                $jsonOutput = substr($jsonOutput, 0, strlen($jsonOutput)-2);

                        $jsonOutput .= "\n}";

                        return $jsonOutput;

                }//end method


                function _showOpenARSelect($clientid, $type){

                        $queryType = $type;
                        if($type == "credit")
                                $queryType = "credit";

                        $querystatement = "
                                SELECT
                                        `aritems`.`id`,
                                        `aritems`.`uuid`,
                                        `aritems`.`amount`,
                                        `aritems`.`paid`,
                                        `aritems`.`relatedid`,
                                        `aritems`.`itemdate`,
                                        `invoices`.`id` AS `invoiceid`
                                FROM
                                        `aritems` LEFT JOIN `invoices` ON `aritems`.`relatedid`=`invoices`.`uuid`
                                WHERE
                                        `aritems`.`status` = 'open'
                                        AND
                                        `aritems`.`clientid` = '".mysql_real_escape_string($clientid)."'
                                        AND
                                        `aritems`.`type` = '".$queryType."'
                                        AND
                                        `aritems`.`posted` = '1'
                                ORDER BY
                        ";

                                if($type == "credit")
                                        $querystatement .= "itemdate";
                                else
                                        $querystatement .= "relatedid";

                        $queryresult = $this->db->query($querystatement);

                        if($this->db->numRows($queryresult)){
                                ?><select id="newItem<?php echo str_replace(" ","",ucwords($type)) ?>ARID">
                                        <?php

                                        while($therecord = $this->db->fetchArray($queryresult)){

                                                ?><option value="<?php echo $therecord["uuid"]?>"><?php

                                                        if($therecord["invoiceid"])
                                                                echo $therecord["invoiceid"].": ";

                                                        echo formatFromSQLDate($therecord["itemdate"])." ";
                                                        echo formatVariable($therecord["amount"], "currency");

                                                        if($therecord["paid"] != 0)
                                                                echo " (".formatVariable(((real) $therecord["amount"]) - ((real) $therecord["paid"]), "currency").")";

                                                ?></option><?php

                                        }//endwhile

                                        ?>
                                </select><?php
                        } else {

                                ?><p class="disabledtext">No existing open <?php echo $type ?> AR items found for client.</p><?php

                        } // endif

                }//end method


                function getAddNewDialog($clientid){

                        include("include/fields.php");


                        ?>
                        <fieldset>
                                <legend>type</legend>

                                <p>
                                        <select id="newItemType">
                                                <option value="credit">credit</option>
                                                <option value="invoice">invoice</option>
                                                <option value="service charge">service charge</option>
                                        </select>
                                </p>

                        </fieldset>

                        <fieldset id="newItemCreditFieldset">
                                <legend>Credits</legend>

                                <p id="newItemCreditNewP">
                                        <input type="radio" class="radiochecks" name="newItemCreditType" id="newItemCreditNew" checked="checked"/>
                                        <label for="newItemCreditNew">new</label>
                                </p>

                                <p id="newItemCreditExistingP">
                                        <input type="radio" class="radiochecks" name="newItemCreditType" id="newItemCreditExisting"/>
                                        <label for="newItemCreditExisting">existing credit</label>
                                </p>

                                <p id="newItemExisingListP">
                                        <?php $this->_showOpenARSelect($clientid, "credit"); ?>
                                </p>
                        </fieldset>

                        <fieldset id="newItemInvoiceFieldset">
                                <legend>Invoice AR Items</legend>
                                <p>
                                        <?php $this->_showOpenARSelect($clientid, "invoice"); ?>
                                </p>
                        </fieldset>

                        <fieldset id="newItemServiceChargeFieldset">
                                <legend>Service Charges</legend>
                                <p>
                                        <?php $this->_showOpenARSelect($clientid, "service charge"); ?>
                                </p>
                        </fieldset>

                        <p class="standout" id="newItemMessage">&nbsp;</p>

                        <p align="right">
                                <button type="button" id="newItemLoadButton" class="Buttons">add</button>
                                <button type="button" id="newItemCancelButton" class="Buttons">cancel</button>
                        </p>
                        <?php

                }
        }//end class


//PROCESSOR
//=============================================================================
        if(isset($_GET["cm"])){

                $processor = new receiptARItemAjax($db);
                if(!isset($_GET["cid"]))
                        $_GET["cid"] = "";

                switch($_GET["cm"]){

                        case "getAllOpen":

                                $result = $processor->getItemsByClient($_GET["cid"]);
                                echo $processor->outputItemsJSON($result);
                                break;

                        case "getAddNewDialog":

                                $processor->getAddNewDialog($_GET["cid"]);
                                break;

                        case "getARItem":

                                if(!isset($_GET["arid"]))
                                        $_GET["arid"] = "";

                                $result = $processor->getItemByID($_GET["arid"]);
                                echo $processor->outputItemsJSON($result);
                                break;

                }//endswitch

        }//end if
?>