HEX
Server: Apache
System: Linux server1.royalgt4.com 4.18.0-553.89.1.lve.el8.x86_64 #1 SMP Wed Dec 10 13:58:50 UTC 2025 x86_64
User: mostafedeg (1125)
PHP: 5.6.40
Disabled: mail,passthru,parse_ini_file,show_source,eval,assert,pcntl_exec,dl,putenv,proc_open,popen
Upload Files
File: /home/mostafedeg/public_html/erp/controllers/marchSalaReport.php
<?php

// كنترول الموظفين
//
//the global file operation
include("../public/impOpreation.php");

//global varable
global $showoutside;

//to check if the page from .htacess
//$showoutside = $_GET['sn'];
// get the config file
include_once("../public/config.php");

//here the db files that include in the file
include("../public/include_dao.php");

require_once('../models/dao/EmployeeDAO.class.php');
require_once('../models/dto/Employee.class.php');
require_once('../models/mysql/EmployeeMySqlDAO.class.php');
require_once('../models/mysql/ext/EmployeeMySqlExtDAO.class.php');

require_once('../models/dao/YoutubeLinkDAO.class.php');
require_once('../models/dto/YoutubeLink.class.php');
require_once('../models/mysql/YoutubeLinkMySqlDAO.class.php');
require_once('../models/mysql/ext/YoutubeLinkMySqlExtDAO.class.php');

$do = $_GET['do'];
$langs = $_SESSION['erp_lang'];
include_once("../views/languages/$langs/success.php");
include_once("../views/languages/$langs/error.php");

$smarty->display("header.html");


//create object  from employee
$employeeDAO = new EmployeeMySqlDAO();
$employee = new Employee();
$employeeEX = new EmployeeMySqlExtDAO();

$EmployeepersonnelDAO = new EmployeepersonnelMySqlDAO();
$Employeepersonnel = new Employeepersonnel();
$EmployeepersonnelEX = new EmployeepersonnelMySqlExtDAO();

$youtubeLink = new YoutubeLink();
$youtubeLinkDAO = new YoutubeLinkMySqlDAO();
$youtubeLinkEX = new YoutubeLinkMySqlExtDAO();

//create object from user
//dispaly  add form
if (empty($do)) {
    include_once("../public/authentication.php");

    $queryString = '';
    if ($_SESSION['branchId'] > 0)
    $queryString = ' AND  branchid = ' . $_SESSION['branchId'];
    
    $allemployee = $employeeEX->queryAllSimple($queryString);
    $smarty->assign('allemployee', $allemployee);

    $empid = filter_input(INPUT_POST, "chooseEmp");
    $smarty->assign('empid', $empid);

    $youtubes = $youtubeLinkDAO->queryAll();
    $smarty->assign("youtubes", $youtubes);

    $queryString = "";
    if (!empty($empid)) {


        $employeeData = $employeeDAO->load($empid);

        $smarty->assign('employeeData', $employeeData);

        $salary1 = $salary2 = $salary3 = $salary4 = $salary5 = $salary7 = '0';
        $prsonalEmployee = $EmployeepersonnelDAO->queryByEmployeeid($empid);


        foreach ($prsonalEmployee as $persData) {
            if ($persData->employeepersonneltype == 1 && $persData->conditions == 0) {
                $salary1 += $persData->employeepersonnelvalue; // مكافاة
            } elseif ($persData->employeepersonneltype == 2 && $persData->conditions == 0) {
                $salary2 += $persData->employeepersonnelvalue; // خصم
            } elseif ($persData->employeepersonneltype == 3 && $persData->conditions == 0) {
                $salary3 += $persData->employeepersonnelvalue; // سحب
            } elseif ($persData->employeepersonneltype == 4 && $persData->conditions == 0) {
                $salary4 += $persData->employeepersonnelvalue; // سلفة
            } elseif ($persData->employeepersonneltype == 9 && $persData->conditions == 0) {
                $salary5 += $persData->employeepersonnelvalue; // غياب
            } elseif ($persData->employeepersonneltype == 7 && $persData->conditions == 0) {
                $salary7 += $persData->employeepersonnelvalue; // سداد سلفة من المرتب
            }
        }
        // print_r($salary1 . '<br>' . $salary2 . '<br>' . $salary3 . '<br>' . $salary4 . '<br>' . $salary5 . '<br>' . $salary7);
        $salary = array();
        array_push($salary, $salary1, $salary2, $salary3, $salary4, $salary5, $salary7);
        $smarty->assign('salary', $salary);
        $bonuses = $_POST['bonuses'];
        $smarty->assign('sum', $bonuses);
    }


    $smarty->assign("customMarchSalary", 1);

    $smarty->display("marchesSalaries/show.html"); //the template page
} elseif ($do == 'editprint') {

    $empSalary = $_POST['empSalary']; // المرتب الاساسى
    $bonuses = $_POST['bonuses']; // المكافأت
    $houseAllowance = $_POST['houseAllowance']; // بدل سكن
    $payAdvances = $_POST['payAdvances']; // دفع السلف
    $transportationAllowance = $_POST['transportationAllowance']; // بدل المواصلات
    $otherAllowance = $_POST['otherAllowance']; // بدلات اخرى
    $absence_delay = $_POST['absence_delay']; // تاخير-غياب
    $discounts = $_POST['discounts']; // الخصومات
    $withdrawals = $_POST['withdrawals']; // المسحوبات
    $predecessor = $_POST['predecessor']; // السلف
    $employeId = filter_input(INPUT_POST, 'emplId');
    $employeeData = $employeeDAO->load($employeId);
    $empName = $employeeData->employeeName; // اسم الموظف
    $eradat = $bonuses + $houseAllowance + $payAdvances + $transportationAllowance + $otherAllowance + $empSalary; // جمع الايرادات
    $disc = $absence_delay + $discounts + $withdrawals + $predecessor; // جمع المصروفات
    $sub = $eradat - $disc; // صافى المرتب

    $prnData = array();
    array_push($prnData, $empSalary, $bonuses, $houseAllowance, $payAdvances, $transportationAllowance, $otherAllowance, $absence_delay, $discounts, $withdrawals, $predecessor, $sub, $empName, $eradat, $disc);


    $smarty->assign('prnData', $prnData);
    $smarty->display("marchesSalaries/editprint.html"); //the template page
}
//success
elseif ($_GET['do'] == "sucess") {
    $smarty->display("succes.html");
} elseif ($_GET['do'] == "error") {
    $smarty->display("error.html");
}
$smarty->assign("customValidation", 1);
$smarty->display("footer.html");