$log = new log();
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
    case 'get_add_page':
        $page = GetPage();
        $data = array('page' => $page);
        break;
    case 'get_edit_page':
        $rec_id = $_REQUEST['id'];
        $page = GetPage(GetRecipie($rec_id));
        $data = array('page' => $page);
        break;
    case 'get_local_id':
        $data = array('local_id' => GetLocalID());
        break;
    case 'get_list':
        $count = $_REQUEST['count'];
        $hidden = $_REQUEST['hidden'];
        $rResult = mysql_query("SELECT  production.`id`,      \r\n\t\t\t\t\t\t\t\t\t\t`production`.`name`,\r\n\t\t\t\t\t\t\t\t\t\tROUND(SUM((SELECT DISTINCT reserve.price FROM reserve WHERE reserve.production_id = rec.ingredient_id ) * rec.quantity * rec.default_amount),4)  AS `self_price`       \r\n\t\t\t\t\t\t\t\t\t\tFROM         `recipie` AS rec \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `production` ON `production`.`id` = `rec`.`recipie_id`\r\n\t\t\t\t\t\t\t\t\t\tWHERE `production`.`id` IN (SELECT `recipie_id` FROM `recipie`) AND `production`.`actived` = 1\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY     rec.recipie_id");
        $data = array("aaData" => array());
        if (!$rResult) {
            $error = 'Invalid query: ' . mysql_error();
        } else {
            while ($aRow = mysql_fetch_array($rResult)) {
                $row = array();
                for ($i = 0; $i < $count; $i++) {
                    /* General output */
                    $row[] = $aRow[$i];
                    if ($i == $count - 1) {
Exemplo n.º 2
0
        $rResult = mysql_query("SELECT\r\n\t\t\t\t\t\t\t\t\t\t\t`c_person`,\r\n\t\t\t\t\t\t\t\t\t\t\t`phone`,\r\n\t\t\t\t\t\t\t\t\t\t\t`email`\r\n\t\t\t\t\t\t\t\t\tFROM    `bank_person`\r\n\t\t\t\t\t\t\t\t\tWHERE\t c_person={$object_id} AND  actived=1");
        $data = array("aaData" => array());
        while ($aRow = mysql_fetch_array($rResult)) {
            $row = array();
            for ($i = 0; $i < $count; $i++) {
                /* General output */
                $row[] = $aRow[$i];
                if ($i == $count - 1) {
                    $row[] = '<input type="checkbox" name="check_' . $aRow[$hidden] . '" class="check" value="' . $aRow[$hidden] . '" />';
                }
            }
            $data['aaData'][] = $row;
        }
        break;
    case 'get_local_id':
        $increment_id = GetLocalID();
        $data = array('increment' => $increment_id);
        break;
    case 'disable':
        Deleteobj($_REQUEST['id']);
        break;
    default:
        $error = 'Action is Null';
}
$data['error'] = $error;
echo json_encode($data);
/* ******************************
 *	Recipie obj List Functions
* ******************************
*/
function Addbank_object($bank_object_name, $bank_object_address)
        Done($describe_id, $user_id, $object_id, $c_date);
        break;
    case 'check_prod_list':
        $describe_id = $_REQUEST['id'];
        $check = CheckProdList($describe_id);
        if ($check) {
            $error = 'პროდუქციის სია ცარიელია!';
        }
        break;
    case 'get_production_quantity':
        $production_name = $_REQUEST['pn'];
        $object_id = $_REQUEST['ob'];
        $data = array('quantity' => GetQuantity($production_name, $object_id));
        break;
    case 'get_local_id':
        $local_id = GetLocalID();
        $data = array('local_id' => $local_id);
        break;
    case 'clear_db':
        ClearDB();
        break;
    default:
        $error = 'Action is Null';
}
$data['error'] = $error;
echo json_encode($data);
/* ******************************
 *	Transfer Functions
 * ******************************
 */
function ClearDB()
Exemplo n.º 4
0
function GetCalientCallPage($id)
{
    if ($id == '') {
        $res['id'] = GetLocalID();
    } else {
        $res = GetCall($id);
    }
    $data = '
	<div id="dialog-form">
	    <fieldset>
	    	<legend>ძირითადი ინფორმაცია</legend>
    		<table class="dialog-form-table">
				<tr>
					<td style="width: 170px;"><label for="client_object">კლიენტი</label></td>
					<td>
						<div class="seoy-row" id="client_object_seoy">
							<input type="text" id="client_object" class="idle seoy-large" onblur="this.className=\'idle seoy-large\'" onfocus="this.className=\'activeField seoy-large\'" value="' . $res['client'] . '" />
							<button id="client_object_btn" class="combobox">client_object</button>
						</div>
					</td>
				</tr>		
				<tr>
					<td style="width: 170px;"><label for="per_contact_person">საკონტაქტო პირი</label></td>
					<td>
						<select id="persons" class="idls date_time" style="width: 165px !important;">' . GetPersons($res['id']) . '</select>
					</td>
				</tr>	
																			
				<tr>
					<td style="width: 170px;"><label for="per_phone_number">ტელ. ნომერი</label></td>
					<td>
						<input type="text" id="per_phone_number" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['phone'] . '" />
					</td>
				</tr>
				<tr>
					<td style="width: 170px;"><label for="per_mail">ელ-ფოსტა</label></td>
					<td>
						<input type="text" id="per_mail" class="idle" onblur="this.className=\'idle\'" onfocus="this.className=\'activeField\'" value="' . $res['mail'] . '" />
					</td>
				</tr>
				<tr>
					<td style="width: 170px;"><label for="service_degree">მომსახურების დონე</label></td>
					<td>
						<select id="service_degree" class="idls date_time" style="width: 165px !important;">' . GetServiceDegree($res['degree_type']) . '</select>
					</td>
				</tr>
				<tr>
					<td style="width: 170px;" valign="top"><label for="call_date">თარიღი</label></td>								
					<td><input id="call_date" type="text" class="idle date_time" onblur="this.className=\'idle date_time\'" onfocus="this.className=\'activeField date_time\'" value="' . $res['call_date'] . '" /></td>
				</tr>	
				<tr class="comment">
					<td style="width: 170px;" valign="top"><label for="per_comment">შენიშვნა</label></td>
					<td>
						<textarea id="per_comment" class="idle large" cols="40" rows="3">' . $res['comment'] . '</textarea>
					</td>
				</tr>
			</table>
			<!-- ID -->
			<input type="hidden" id="servise_degree_id" value="' . $res['id'] . '" />
			<input type="hidden" id="client_name" value="" />
        </fieldset>
    </div>';
    return $data;
}