function GetSisaCuti($id_emp, $date)
{
$hak_cuti = GetValue("hak_cuti", "kg_cuti_platfon", array("id_employee" => "where/" . $id_emp));
$cuti = GetSum("kg_cuti", "hari_ref", array("create_user_id" => "where/" . $id_emp, "tgl_start <=" => "where/" . $date, "cuti_status !=" => "where/Reject"), "value");
$sisa_cuti = $hak_cuti - $cuti;
return $sisa_cuti;
}
include '../../../includes/classes/core.php';
$start = $_REQUEST['start'];
$end = $_REQUEST['end'];
$action = $_REQUEST['act'];
$name = $_REQUEST['name'];
$error = '';
$data = '';
function GetSum($start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT \tIFNULL(ROUND(SUM(sale_transaction_detail.product_quantity*sale_transaction_detail.cost),2),0) AS `sum`\r\n\t\t\t\t\t\t\t\t\t\t FROM sale_transaction\r\n\t\t\t\t\t\t\t\t\t\t JOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\t\t\t\t\t\t\t\t WHERE DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.status=0"));
return $result['sum'];
}
function GetProductSum($name, $start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT \tIFNULL(ROUND(SUM(sale_transaction_detail.product_quantity*sale_transaction_detail.cost),2),0) AS `sum`\r\n\t\t\t\t\t\t\t\t\t\t\t FROM sale_transaction\r\n\t\t\t\t\t\t\t\t\t\t\t JOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\t\t\t\t\t\t\t\t\t JOIN production ON production.id = sale_transaction_detail.production_id \r\n\t\t\t\t\t\t\t\t\t\t\t WHERE production.`name` = '{$name}' AND DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.`status` =0"));
return $result['sum'];
}
switch ($action) {
case 'get_sale_sum':
$data = array('page' => GetSum($start, $end));
break;
case 'get_products_sum':
$page = GetProductSum($name, $start, $end);
$data = array('page' => $page);
break;
default:
echo "Action is null!";
break;
}
$data['error'] = $error;
echo json_encode($data);
}
function Factorial()
{
global $n;
$Result = 1;
for ($i = 2; $i <= $n; $i++) {
$Result = $Result * $i;
}
return $Result;
}
//---------------- Start --------------------
$Numb_1 = 10;
$Numb_2 = 36;
$Sum;
// Возможно 3 обращения к глобальным переменным
GetSum();
echo "{$Numb_1} + {$Numb_2} = {$Sum}\n";
$Numb_1 = 594;
$Numb_2 = 86;
// Возможно 4 обращения
$Diff = GetDifference($Numb_1, $Numb_2);
echo "{$Numb_1} - {$Numb_2} = {$Diff}\n";
$Numb_1 = 22;
$Numb_2 = 6;
$Mult;
// Возможно 5 обращений
GetMult_incorrect_return();
echo "incorrect return Mult result = {$Mult}\n";
// Все еще 5
GetMult_global_return($Numb_1, $Numb_2);
echo "{$Numb_1} * {$Numb_2} = {$Mult}\n";
}
function GetQuantity($start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT IFNULL(SUM(sale_transaction_detail.product_quantity),0) AS `sum`\r\n\t\t\t\t\t\t\t\t\t\t\t FROM sale_transaction\r\n\t\t\t\t\t\t\t\t\t\t\t JOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\t\t\t\t\t\t\t\t\t WHERE DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.status=0"));
return $result['sum'];
}
function GetProductSum($name, $start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT \t\tROUND(SUM(sale_transaction_detail.product_quantity*sale_transaction_detail.cost),2) AS `sum`\r\n\t\t\tFROM sale_transaction\r\n\t\t\tJOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\tJOIN production ON production.id = sale_transaction_detail.production_id\r\n\t\t\tJOIN production_category ON production.pos_menu_category = production_category.id\r\n\t\t\tWHERE production_category.`name` = '{$name}' AND production_category.`name` IS NOT NULL AND DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.`status` =0"));
return $result['sum'];
}
function GetProductQuantity($name, $start, $end)
{
$result = mysql_fetch_assoc(mysql_query("SELECT SUM(sale_transaction_detail.product_quantity) AS `sum`\r\n\t\t\tFROM sale_transaction\r\n\t\t\tJOIN sale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\r\n\t\t\tJOIN production ON production.id = sale_transaction_detail.production_id\r\n\t\t\tJOIN production_category ON production.pos_menu_category = production_category.id\r\n\t\t\tWHERE production_category.`name` = '{$name}' AND production_category.`name` IS NOT NULL AND DATE(`sale_transaction`.`end_date`) >= '{$start}' AND DATE(`sale_transaction`.`end_date`) <= '{$end}' AND sale_transaction.`status` =0"));
return $result['sum'];
}
switch ($action) {
case 'get_category_sum':
$data = array('page' => array(GetSum($start, $end), GetQuantity($start, $end)));
break;
case 'get_products_sum':
$sum = GetProductSum($name, $start, $end);
$qnt = GetProductQuantity($name, $start, $end);
$data = array('page' => array($sum, $qnt));
break;
default:
echo "Action is null!";
break;
}
$data['error'] = $error;
echo json_encode($data);
function list_cuti($report = NULL, $tgl = NULL, $div = NULL, $sec = NULL, $pos = NULL, $grade = NULL)
{
permission();
$data['path_file'] = $this->filename;
if ($this->input->post("start_att") || $tgl) {
if ($tgl) {
$exp = explode("~", $tgl);
$data['start_date'] = $exp[0];
$data['end_date'] = $exp[1];
} else {
$data['start_date'] = $this->input->post("start_att");
if (!$this->input->post("end_att")) {
$data['end_date'] = $data['start_date'];
} else {
$data['end_date'] = $this->input->post("end_att");
}
}
$data['period'] = GetMonth(substr($data['end_date'], 5, 2)) . " " . substr($data['end_date'], 0, 4);
} else {
$dt = "Dec 2015";
//date("M Y");
$period = GetPeriod($dt);
$data['start_date'] = substr($period, 0, 10);
$data['end_date'] = substr($period, 11, 10);
$data['period'] = $dt;
}
$data['jum_kolom'] = 5;
$tgl = $data['start_date'] . "~" . $data['end_date'];
$data['div'] = $this->input->post('s_div') ? $this->input->post('s_div') : $div;
$data['sec'] = $this->input->post('s_sec') ? $this->input->post('s_sec') : $sec;
$data['pos'] = $this->input->post('s_pos') ? $this->input->post('s_pos') : $pos;
$data['grade'] = $this->input->post('s_grade') ? $this->input->post('s_grade') : $grade;
$this->load->model('cuti_model', 'cuti');
$param = array("tgl" => $tgl, "divisi" => $data['div'], "section" => $data['sec'], "position" => $data['pos'], "grade" => $data['grade']);
$list = $this->cuti->get_datatables($param);
$dataz = array();
$no = 0;
foreach ($list->result() as $r) {
$no++;
$sisa_cuti = GetSisaCuti($r->id_employee, $data['start_date']);
$terpakai = GetSum("kg_cuti", "hari_ref", array("tgl_start >=" => "where/" . $data['start_date'], "tgl_start <=" => "where/" . $data['end_date'], "create_user_id" => "where/" . $r->id_employee, "cuti_status" => "where/Approve"), "value");
$dataz[] = array($no, $r->ext_id, $r->person_nm, $sisa_cuti, $terpakai, $sisa_cuti - $terpakai);
}
$data['list'] = $dataz;
$data['report'] = $report;
if (!$report) {
$this->load->view('r_list_cuti', $data);
} else {
to_excel($this->load->view('r_list_cuti', $data), 'ReportLeave');
}
}
