function popup()
{
include_once 'kas-tabs.php';
$page = GetPage();
if ($page != null) {
echo $page;
exit;
}
$page = PageKas3MTAClientsSettings();
$html = "<H1>{antispam_engine}</H1>\n\t<div id='global_kas_pages' style='width:100%;height:400px;overflow:auto'>{$page}</div>";
$tpl = new templates();
echo $tpl->_ENGINE_parse_body($html);
}
function _GeneratePages($amount, $amount_on_page)
{
$current_page = GetPage() + 1;
$newsOnPage = $amount_on_page;
$pagesAmount = $newsOnPage != 0 ? ceil($amount / $newsOnPage) : 0;
if ($pagesAmount > 7) {
if ($current_page <= 4) {
$result = array_merge(range(1, $current_page + 2), array('...', $pagesAmount));
} elseif ($current_page > 4 and $pagesAmount - $current_page > 4) {
$result = array_merge(array(1, '...'), range($current_page - 2, $current_page + 2), array('...', $pagesAmount));
} elseif ($pagesAmount - $current_page <= 4) {
$result = array_merge(array(1, '...'), range($current_page - 2, $pagesAmount));
}
} elseif ($pagesAmount == 0) {
$result = [1];
} else {
$result = range(1, $pagesAmount);
}
return [$current_page - 1, ['amount' => $pagesAmount, 'num' => $result]];
}
$quest_detail_id = $_REQUEST['quest_detail_id'];
$add_id = $_REQUEST['add_id'];
$name = $_REQUEST['name'];
$note = $_REQUEST['note'];
$answer = $_REQUEST['answer'];
$quest_type_id = $_REQUEST['quest_type_id'];
$quest_id1 = $_REQUEST['quest_id1'];
$cat = $_REQUEST['cat'];
$le_cat = $_REQUEST['le_cat'];
switch ($action) {
case 'get_add_page':
$page = GetPage(GetList($add_id));
$data = array('page' => $page);
break;
case 'get_edit_page':
$page = GetPage(GetList($quest_id, $quest_detail_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \t`scenario`.`id`,\r\n \t\t\t\t`scenario`.`name`,\r\n \t\t\t\t`cat`.`name`,\r\n \t\t\t\t`le_cat`.`name`\r\n FROM \t`scenario`\r\n JOIN `scenario_category` AS `cat` ON `scenario`.`scenario_cat_id` = `cat`.`id`\r\n JOIN `scenario_category` AS `le_cat` ON `scenario`.`scenario_le_cat_id` = `le_cat`.`id`\r\n WHERE \t`scenario`.`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] . '" />';
}
<?php
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$departmetn_id = $_REQUEST['id'];
$page = GetPage(Getdepartment($departmetn_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tdepartment.id,\r\n\t\t department.id,\r\n\t\t\t\t\t\t\t\t\t\tdepartment.`name`\r\n\t\t\t\t\t\t\t FROM \tdepartment\r\n\t\t\t\t\t\t\t WHERE \tdepartment.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[] = '<div class="callapp_checkbox">
<input type="checkbox" id="callapp_checkbox_' . $aRow[$hidden] . '" name="check_' . $aRow[$hidden] . '" value="' . $aRow[$hidden] . '" class="check" />
<label for="callapp_checkbox_' . $aRow[$hidden] . '"></label>
</div>';
<?php
require_once '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$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':
$source_id = $_REQUEST['id'];
$page = GetPage(Getsource($source_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tsource.id,\r\n\t\t\t\t\t\t\t\t\t\tsource.`name`\r\n\t\t\t\t\t\t\t FROM \tsource\r\n\t\t\t\t\t\t\t WHERE \tsource.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] . '" />';
}
$template_id = $_REQUEST['template_id'];
$priority_id = $_REQUEST['priority_id'];
$comment = $_REQUEST['comment'];
$hidden_inc = $_REQUEST['hidden_inc'];
$edit_id = $_REQUEST['edit_id'];
$delete_id = $_REQUEST['delete_id'];
// file
$rand_file = $_REQUEST['rand_file'];
$file = $_REQUEST['file_name'];
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$page = GetPage(Getincomming($task_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$user_id = $_REQUEST['user_id'];
$user = $_SESSION['USERID'];
$group = checkgroup($user);
$filter = '';
if ($group != 2) {
$filter = 'AND outgoing_call.responsible_user_id =' . $user;
}
$rResult = mysql_query("SELECT \t \t`task`.id,\r\n\t\t\t\t\t\t\t\t\t\t\t`task`.id,\r\n\t\t\t\t\t\t\t\t\t\t\t`site_user`.`name`,\r\n\t\t\t\t\t\t\t\t\t\t\t`site_user`.`pin`,\r\n\t\t\t\t\t\t\t\t\t\t\t`person1`.`name` ,\r\n\t\t\t\t\t\t\t\t\t\t\t`person2`.`name` ,\r\n\t\t\t\t\t\t\t\t\t\t\t`incomming_call`.date,\r\n\t\t\t\t\t\t\t\t\t\t\t`status`.`call_status`\r\n\t\t\t\t\t\t\t\tFROM \t\ttask\t\t\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN \t\tincomming_call ON task.incomming_call_id=incomming_call.id\r\n\t\t\t\t\t\t\t\tLEFT JOIN \tsite_user\t\tON incomming_call.id=site_user.incomming_call_id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tJOIN \t\tusers AS `user1`\t\t\tON task.responsible_user_id=user1.id\r\n\t\t\t\t\t\t\t\tJOIN \t\tpersons AS `person1`\t\tON user1.person_id=person1.id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tJOIN \t\tusers AS `user2`\t\t\tON task.user_id=user2.id\r\n\t\t\t\t\t\t\t\tJOIN \t\tpersons AS `person2`\t\tON user2.person_id=person2.id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tLEFT JOIN `status` \tON\ttask.`status`= `status`.id\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tWHERE \t\ttask.task_type_id=1 AND task.`status`=1");
$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$status_id = $_REQUEST['id'];
$status_name = $_REQUEST['name'];
$call_status = $_REQUEST['call_status'];
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$template_id = $_REQUEST['id'];
$page = GetPage(Getstatus($status_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tinfo_base.id,\r\n\t\t\t\t\t\t\t\t\t\tinfo_base.`name`\r\n\t\t\t\t\t\t\t\tFROM \tinfo_base\r\n\t\t\t\t\t\t\t WHERE \tinfo_base.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];
}
$data['aaData'][] = $row;
}
<?php
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$call_id = $_REQUEST['id'];
$page = GetPage(GetcallType($call_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tcall_status.id,\n\t\t\t\t\t\t\t\t\t\tcall_status.`name`\n\t\t\t\t\t\t\t FROM \tcall_status\n\t\t\t\t\t\t\t WHERE \tcall_status.actived=1");
$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < $count; $i++) {
$row[] = $aRow[$i];
if ($i == $count - 1) {
$row[] = '<input style="margin-left: 5px;" type="checkbox" name="check_' . $aRow[$hidden] . '" class="check" value="' . $aRow[$hidden] . '" />';
}
}
$data['aaData'][] = $row;
}
<?php
require_once '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$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':
$paytype_id = $_REQUEST['id'];
$page = GetPage(Getpay_type($paytype_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tpay_type.id,\r\n\t\t\t\t\t\t\t\t\t\tpay_type.`name`\r\n\t\t\t\t\t\t\t FROM \tpay_type\r\n\t\t\t\t\t\t\t WHERE \tpay_type.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] . '" />';
}
<?php
require_once '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$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':
$object_id = $_REQUEST['id'];
$page = GetPage(Getobject($object_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tobject.id,\r\n\t\t\t\t\t\t\t\t\t\tobject.`name`\r\n\t\t\t\t\t\t\t FROM \tobject\r\n\t\t\t\t\t\t\t WHERE \tobject.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] . '" />';
}
*/
include '../../includes/classes/core.php';
include '../../includes/classes/category.tree.class.php';
include '../../includes/classes/log.class.php';
$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();
<?php
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$callstatus_id = $_REQUEST['id'];
$page = GetPage(Getcall_status($callstatus_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tid,\r\n\t\t\t\t\t\t\t\t\t\t`name`\r\n\t\t\t\t\t\t\t FROM \tsource\r\n\t\t\t\t\t\t\t WHERE \tactived=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;
<?php
require_once '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$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':
$position_id = $_REQUEST['id'];
$page = GetPage(Getposition($position_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \t position.id,\r\n\t\t\t\t\t\t\t\t\t\t position.`person_position`\r\n\t\t\t\t\t\t\t FROM \t\tposition\r\n\t\t\t\t\t\t\t WHERE \t\tposition.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] . '" />';
}
*/
include '../../includes/classes/core.php';
include '../../includes/classes/logger.class.php';
$action = $_REQUEST['act'];
$user_id = $_COOKIE['USERID'];
$error = '';
$data = '';
//$_log = Logger::instance('../../log/operations/transfer/', Logger::OFF);
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$rec_id = $_REQUEST['id'];
$page = GetPage(GetDescribe($rec_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \t\t`describe`.`id`,\n\t\t\t\t\t\t\t\t\t\t\t`describe`.`date`,\n\t \t\t\t\t\t\t\t\t\t`object`.`name`,\n\t\t\t\t\t\t\t\t\t\t\t`persons`.`name`,\n \t\t\t\t\t\t\t\t\t\tif( `describe`.`status` = 0 , 'აქტიური', 'დასრულებული') as `status`\n\t\t\t\t\t\t\t\tFROM \t\t`describe`\n\t\t\t\t\t\t\t\tLEFT JOIN \t`persons` ON `describe`.`person_id` = `persons`.`id`\n\t \t\t\t\t\t\tLEFT JOIN\t`object` ON `object`.`id` = `describe`.`object_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];
include '../../includes/classes/core.php';
include '../../includes/classes/logger.class.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$user_id = $_COOKIE['USERID'];
$_log = Logger::instance('../../log/documents/overhead/', Logger::OFF);
switch ($action) {
case 'get_add_page':
$o_type = $_REQUEST['ot'];
$page = GetPage('', $o_type);
$data = array('page' => $page);
break;
case 'get_edit_page':
$overhead_id = $_REQUEST['id'];
$page = GetPage(GetOverhead($overhead_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$type = $_REQUEST['type'];
$confirm = $_REQUEST['confirm'];
//Out
if ($type == 0 || $type == 0) {
$rResult = mysql_query("SELECT `O`.`id` AS `id`,\n\t\t\t\t\t\t\t\t\t\t `O`.`waybill_number`,\n\t\t\t\t\t\t\t\t\t\t `OT`.`name` AS `type`,\n\t\t\t\t\t\t\t\t\t\t IFNULL(CONCAT('(',`O`.`buyer_tin`,') ', `O`.`buyer_name`),'()') AS `partner`,\n\t\t\t\t\t\t\t\t\t\t `O`.`full_amount`,\n\t\t\t\t\t\t\t\t\t\t `O`.`activate_date`\n\t\t\t\t\t\t\t\t\tFROM `overhead` AS `O` LEFT JOIN `overhead_types` AS `OT`\n\t\t\t\t\t\t\t\t\t\tON `O`.`type` = `OT`.`id`\n\t\t\t\t\t\t\t\t\tWHERE `O`.`stream` = {$type}");
//In UnConfirmed
} else {
if ($type == 1 && $confirm == 1) {
$rResult = mysql_query("SELECT `O`.`id` AS `id`,\n\t\t\t\t\t\t\t\t\t\t\t `O`.`waybill_number`,\n\t\t\t\t\t\t\t\t\t\t\t `OT`.`name` AS `type`,\n\t\t\t\t\t\t\t\t\t\t\t IFNULL(CONCAT('(',`O`.`seller_tin`,') ', `O`.`seller_name`),'()') AS `partner`,\n\t\t\t\t\t\t\t\t\t\t\t `O`.`full_amount`,\n\t\t\t\t\t\t\t\t\t\t\t `O`.`activate_date`\n\t\t\t\t\t\t\t\t\t\tFROM `overhead` AS `O` LEFT JOIN `overhead_types` AS `OT`\n\t\t\t\t\t\t\t\t\t\t\tON `O`.`type` = `OT`.`id`\n\t\t\t\t\t\t\t\t\t\tWHERE `O`.`stream` = {$type} AND O.is_confirmed != 2");
//In Confirmed
$comment = $_REQUEST['comment'];
$task_department_id = $_REQUEST['task_department_id'];
$hidden_inc = $_REQUEST['hidden_inc'];
$edit_id = $_REQUEST['edit_id'];
$delete_id = $_REQUEST['delete_id'];
switch ($action) {
case 'get_add_page':
$number = $_REQUEST['number'];
$page = GetPage($res = '', $number);
$data = array('page' => $page);
break;
case 'disable':
mysql_query("\t\t\tUPDATE `action`\r\n\t\t\t\t\t\t\t\t\t SET `actived`=0\r\n\t\t\t\t\t\t\t\t\t\tWHERE `id`={$action_id} ");
break;
case 'get_edit_page':
$page = GetPage(Getaction($action_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("\tSELECT \t\t\taction.id,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\taction.id,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\taction.start_date,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\taction.end_date,\r\n\t \t action.`name`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\taction.content,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tusers.username\r\n\t\t\t\t\t\t\t\t\tFROM \t\t\taction\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\tJOIN users ON action.user_id=users.id\r\n\t\t\t\t\t\t\t\t\tWHERE \t\t\taction.actived=1 AND action.end_date < NOW()");
$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" id="' . $aRow[$hidden] . '" name="check_' . $aRow[$hidden] . '" class="check_arch" value="' . $aRow[$hidden] . '" />';
}
*/
include '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$log = new log();
$action = $_REQUEST['act'];
$user_id = $_SESSION['USERID'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$per_id = $_REQUEST['id'];
$page = GetPage(GetWorker($per_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("\tSELECT `persons`.`id`,\r\n `persons`.`name`,\r\n `persons`.`tin`,\r\n `position`.`person_position`,\r\n `persons`.`address`\r\n\t\t\t\t\t\t\t\t FROM `persons` INNER JOIN `position`\r\n\t\t\t\t\t\t\t\t\tON `persons`.`position` = `position`.`ID`\r\n\t\t\t\t\t\t\t\t\tWHERE `persons`.`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] . '" />';
}
* Partner Accounts aJax actions
* ******************************
*/
include '../../../includes/classes/core.php';
$action = $_REQUEST['act'];
$user_id = $_SESSION['USERID'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$acc_id = $_REQUEST['id'];
$page = GetPage(GetAccount($acc_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$part_id = $_REQUEST['part_id'];
$rResult = mysql_query("SELECT `partner_accounts`.`id`,\r\n\t\t\t\t\t\t\t\t\t `partner_accounts`.`pay_date`,\r\n\t\t\t\t\t\t\t\t\t `overhead`.`waybill_number`,\r\n\t\t\t\t\t\t\t\t\t `partner_accounts`.`pay_needed`,\r\n\t\t\t\t\t\t\t\t\t `partner_accounts`.`payed`\r\n\t\t\t\t\t\t\t\tFROM `partner_accounts` LEFT JOIN `overhead`\r\n\t\t\t\t\t\t\t\t\tON `partner_accounts`.`overhead_id` = `overhead`.`id`\r\n\t\t\t\t\t\t\t\tWHERE `partner_id` = '{$part_id}' && `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];
}
$data['aaData'][] = $row;
* Partner aJax actions
* ******************************
*/
include '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$user_id = $_COOKIE['USERID'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$part_id = $_REQUEST['id'];
$page = GetPage(GetPartner($part_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT `partniorebi`.`id`,\r\n `partniorebi`.`partn_daaxeleba`,\r\n `partniorebi`.`partn_id_kodi`,\r\n `partniorebi`.`partn_fiz_misamarti`,\r\n `partniorebi`.`partn_org_telefoni`,\r\n `partner_contact_info`.`l_name`,\r\n\t\t\t\t\t\t\t\t\t `pay_method`.`name`\r\n\t\t\t\t\t\t\t FROM `partniorebi` \r\n\t\t\t\t\t\t\t \tLEFT JOIN `partner_contact_info`\r\n\t\t\t\t\t\t\t\t\tON `partniorebi`.`id` = `partner_contact_info`.`partner_id` \r\n\t\t\t\t\t\t\t\t\tLEFT JOIN `pay_method`\r\n\t\t\t\t\t\t\t\t\tON `partniorebi`.`gadaxdis_met` = `pay_method`.`id`\r\n\t\t\t\t\t\t\t\tGROUP BY `partniorebi`.`partn_daaxeleba`\r\n\t\t\t\t\t\t\t\tORDER BY `partniorebi`.`id`");
$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] . '" />';
}
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$rand_file = $_REQUEST['rand_file'];
$file = $_REQUEST['file_name'];
$mail_id = $_REQUEST['mail_id'];
switch ($action) {
case 'send_mail':
if ($_REQUEST['call_type'] == 'inc') {
$out_id = $_REQUEST['incomming_id'];
} else {
$out_id = $_REQUEST['out_id'];
}
$page = GetPage($out_id, GetSMS($mail_id));
$data = array('page' => $page);
break;
case 'send_mail_shablon':
$page = GetShablon();
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$inc_id = $_REQUEST['inc_id'];
$rResult = mysql_query("SELECT sent_mail.id,\r\n\t\t\t\t\t\t\t\t\t sent_mail.date,\r\n\t\t\t\t\t\t\t\t\t sent_mail.address,\r\n\t\t\t\t\t\t\t\t\t sent_mail.`subject`,\r\n\t\t\t\t\t\t\t\t\t IF(sent_mail.`status`=2,'გაგზავნილი','არ გაიგზავნა')\r\n\t\t\t\t\t\t\t\tFROM sent_mail\r\n\t\t\t\t\t\t\t\tWHERE sent_mail.incomming_call_id='{$inc_id}'\r\n\t\t\t\t");
$data = array("aaData" => array());
while ($aRow = mysql_fetch_array($rResult)) {
$row = array();
for ($i = 0; $i < $count; $i++) {
$action = $_REQUEST['act'];
$error = '';
$data = '';
$par_id = $_REQUEST['par_id'];
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_cat':
$page = Get_Category('', $_REQUEST['ch_ubani']);
$data = array('page' => $page);
break;
case 'get_edit_page':
$cat_id = $_REQUEST['id'];
$page = GetPage(GetCategory($cat_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT\t`info`.`id`,\r\n\t `info`.`id`,\r\n \t\tIF(info.parent_id = 0,`info`.`name`,(SELECT `name` FROM `service_center` WHERE `id` = `info`.`parent_id`)),\r\n IF(info.parent_id = 0,'',(SELECT `name` FROM `service_center` WHERE `id` = `info`.`id`)),\r\n\t `branch`.`name`\r\n\t\t\t\t\t\t\t FROM\t`service_center` AS `info`\r\n\t LEFT JOIN branch ON branch.id = info.branch_id\r\n\t \t\t\t\t\t\tWHERE\t`info`.`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[] = '<div class="callapp_checkbox">
<input type="checkbox" id="callapp_checkbox_' . $aRow[$hidden] . '" name="check_' . $aRow[$hidden] . '" value="' . $aRow[$hidden] . '" class="check" />
*/
include '../../../includes/classes/core.php';
include '../../../includes/classes/log.class.php';
$log = new log();
$action = $_REQUEST['act'];
$user_id = $_COOKIE['USERID'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$cadre_id = $_REQUEST['id'];
$page = GetPage(GetCadre($cadre_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$partner_id = $_REQUEST['partner_id'];
$rResult = mysql_query("SELECT\t`id`,\r\n\t\t\t\t\t\t\t\t\t \t`person_id`,\r\n\t\t\t\t\t\t\t\t\t \t`f_name`,\r\n\t\t\t\t\t\t\t\t\t \t`l_name`,\r\n\t\t\t\t\t\t\t\t\t \t`position`\r\n\t\t\t\t\t\t\t\tFROM\t`partner_persons`\r\n\t\t\t\t\t\t\t\tWHERE \t`partner_id` = {$partner_id} && `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] . '" />';
<?php
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$lang_id = $_REQUEST['id'];
$page = GetPage(GetLang($lang_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \t`work_activities`.`id`,\r\n\t\t `work_activities`.`name`,\r\n\t\t `work_activities_cat`.`name`,\r\n\t\t `work_pay`.`name`,\r\n\t\t `work_activities`.`comment`,\r\n\t\t `project`.`name`,\r\n\t\t `work_activities`.`timer`,\r\n\t\t CONCAT('<div style=\"height: 100%; weight: 100%; background: ',`work_activities`.`color`,'\"></div>') AS `color`\r\n FROM `work_activities`\r\n\t\t JOIN work_pay ON work_activities.pay = work_pay.id\r\n\t\t JOIN work_activities_cat ON work_activities.work_activities_cat_id = work_activities_cat.id\r\n\t\t JOIN project ON work_activities.project_id = project.id\r\n WHERE `work_activities`.`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[] = '<div class="callapp_checkbox">
<input type="checkbox" id="callapp_checkbox_' . $aRow[$hidden] . '" name="check_' . $aRow[$hidden] . '" value="' . $aRow[$hidden] . '" class="check" />
<label for="callapp_checkbox_' . $aRow[$hidden] . '"></label>
</div>';
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$template_id = $_REQUEST['id'];
$template_name = $_REQUEST['name'];
$content = $_REQUEST['content'];
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$template_id = $_REQUEST['id'];
$page = GetPage(Gettemplate($template_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tpattern.id,\r\n\t\t\t\t\t\t\t\t\t\tpattern.`name`\r\n\t\t\t\t\t\t\t FROM \tpattern\r\n\t\t\t\t\t\t\t WHERE \tpattern.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];
}
$data['aaData'][] = $row;
}
* Client Object List aJax actions
* ******************************
*/
include '../../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$user_id = $_COOKIE['USERID'];
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$list_id = $_REQUEST['id'];
$page = GetPage(GetObjectList($list_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$local_id = $_REQUEST['local_id'];
$rResult = mysql_query("SELECT\t\t`client_objects`.`id`,\r\n\t \t\t\t\t\t\t\t\t\t`client_objects`.`name`,\r\n\t\t\t\t\t\t\t\t\t\t\t`client_objects`.`address`,\r\n\t\t\t\t\t\t\t\t\t\t\t`district_type`.`name`,\r\n\t\t\t\t\t\t\t\t\t\t\t`client_objects`.`contact_person`,\r\n\t\t\t\t\t\t\t\t\t\t\t`client_objects`.`phone_number`\r\n\t\t\t\t\t\t\t\tFROM\t\t`client_objects` \r\n\t\t\t\t\t\t\t\tLEFT JOIN \t`client` ON\t`client_objects`.`client_id` = `client`.`id`\r\n\t\t\t\t\t\t\t\tLEFT JOIN\t`district_type` ON `district_type`.`id` = `client_objects`.`district_type`\r\n\t\t\t\t\t\t\t\tWHERE\t\t`client`.`id` = '{$local_id}' && `client_objects`.`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] . '" />';
<?php
require_once '../../includes/classes/core.php';
include '../../includes/classes/log.class.php';
$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':
$problem_id = $_REQUEST['id'];
$page = GetPage(Getproblem($problem_id));
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT \tproblem.id,\r\n\t\t\t\t\t\t\t\t\t\tproblem.`name`\r\n\t\t\t\t\t\t\t FROM \tproblem\r\n\t\t\t\t\t\t\t WHERE \tproblem.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] . '" />';
}
<?php
/* ******************************
* Category aJax actions
* ******************************
*/
include '../../includes/classes/core.php';
include '../../includes/classes/category.tree.class.php';
include '../../includes/classes/log.class.php';
$log = new log();
$action = $_REQUEST['act'];
$error = '';
$data = '';
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$hidden = $_REQUEST['hidden'];
$rResult = mysql_query("SELECT\t `sale_transaction`.`id`,\r\n\t\t\t\t\t\t\t\t\t\t `sale_transaction`.`end_date`,\r\n\t \t\t\t\t\t\t\t\t `persons`.`name`,\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\t `sale_transaction_detail`.`product_quantity`\r\n\t\t\t\t\t\t\t\t FROM `sale_transaction`\r\n\t\t\t\t\t\t\t LEFT JOIN `users` ON `users`.`id` = `sale_transaction`.`user_id`\r\n\t\t\t\t\t\t\t LEFT JOIN `persons` ON `persons`.`id` = `users`.`person_id`\r\n\t\t\t\t\t\t\t LEFT JOIN `sale_transaction_detail` ON `sale_transaction_detail`.`transaction_id` = `sale_transaction`.`id`\r\n\t\t\t\t\t\t\t LEFT JOIN `production` ON `production`.`id` = `sale_transaction_detail`.`production_id`\r\n\t\t\t\t\t\t\t WHERE `sale_transaction`.`status` = 5");
$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] . '" />';
}
require_once '../../includes/classes/core.php';
$action = $_REQUEST['act'];
$error = '';
$data = '';
$status_id = $_REQUEST['id'];
$status_name = $_REQUEST['name'];
$call_status = $_REQUEST['call_status'];
switch ($action) {
case 'get_add_page':
$page = GetPage();
$data = array('page' => $page);
break;
case 'get_edit_page':
$template_id = $_REQUEST['id'];
$page = GetPage(Getedit($status_id));
$data = array('page' => $page);
break;
case 'clean_base':
$template_id = $_REQUEST['id'];
$page = GetPageCleanBase();
$data = array('page' => $page);
break;
case 'delete_base':
$clean_date = $_REQUEST['clean_date'];
mysql_query("DELETE FROM `phone`\r\n\t\t WHERE DATE_FORMAT(create_date, '%Y-%m-%d') = '{$clean_date}'");
break;
case 'get_list_import':
// DB table to use
$table = 'phone';
// Table's primary key
$file = $_REQUEST['file_name'];
$hidden_inc = $_REQUEST['hidden_inc'];
$edit_id = $_REQUEST['edit_id'];
$delete_id = $_REQUEST['delete_id'];
switch ($action) {
case 'get_add_page':
$number = $_REQUEST['number'];
$page = GetPage($res = '', $number);
$data = array('page' => $page);
break;
case 'disable':
$incom_id = $_REQUEST['id'];
mysql_query("\t\t\tUPDATE `incomming_call`\n\t\t\t\t\t\t\t\t\t SET `actived`=0\n\t\t\t\t\t\t\t\t\t\tWHERE `id`={$incom_id} ");
break;
case 'get_edit_page':
$page = GetPage(Getincomming($id));
$data = array('page' => $page);
break;
case 'get_hint':
$hint = $_REQUEST['hint'];
$req = mysql_fetch_array(mysql_query("SELECT hint\n \t FROM `tage`\n \t WHERE `name` = '{$hint}';"));
$page = '<div id="dialog-form">
<fieldset>
<legend>ძირითადი ინფორმაცია</legend>
<textarea style="height: 220px;width: 443px;">' . $req[0] . '</textarea>
</fieldset>
</div>';
$data = array('page' => $page);
break;
case 'get_list':
$count = $_REQUEST['count'];
$Sort[$i] = $Data[$i];
}
}
rsort($Sort);
for ($i = 0; $i < count($Sort); $i++) {
$InData = GetPage($Sort[$i]);
if ($InData["priority"] == "high") {
$Sorted[] = $Sort[$i];
}
}
for ($i = 0; $i < count($Sort); $i++) {
$InData = GetPage($Sort[$i]);
if ($InData["priority"] == "standard") {
$Sorted[] = $Sort[$i];
}
}
for ($i = 0; $i < count($Sorted); $i++) {
$InData = GetPage($Sorted[$i]);
$Pagetext .= "<h2>{$InData["title"]}<span>{$InData["date"]} {$InData["time"]}</span></h2>\n";
$Line = explode("\n", rtrim(file_get_contents("page/{$Sorted[$i]}/{$InData["filename"]}"), "\n"));
if (count($Line) < 5) {
$cnt = count($Line);
} else {
$cnt = 5;
}
for ($s = 0; $s < $cnt; $s++) {
$Pagetext .= ParseFile($InData["type"], $Line[$s] . "\n");
}
$Pagetext .= "<br>\n";
$Pagetext .= "<a href=\"index.php?q={$Sorted[$i]}\">Read more...</a>";
}
