db = $db;
$this->userCategoryArray = [1 => "sales / kereskedő", 2 => "office / irodai dolgozó", 3 => "management / vezetőség", 4 => "maintenance / szerelő", 5 => "host(ess) / buszkísérő", 6 => "accounts / elszámolók", 7 => "hotelsales"];
}
/**
* Output the buttons to submit a creation/edit form
*
* @param string $save_label Alternative label for save button
* @param string $cancel_label Alternative label for cancel button
* @param array $morebuttons Add additional buttons between save and cancel
* @param bool $withoutdiv Option to remove enclosing centered div
* @param string $morecss More CSS
* @param string $dol_openinpopup If the button are shown in a context of a page shown inside a popup, we put here the string name of popup.
* @return string Html code with the buttons
*/
public function buttonsSaveCancel($save_label = 'Save', $cancel_label = 'Cancel', $cancelURL = '', $morebuttons = array(), $withoutdiv = 0, $morecss = '', $dol_openinpopup = '')
{
global $langs;
$buttons = array();
$save = array(
'name' => 'save',
'label_key' => $save_label,
);
if ($save_label == 'Create' || $save_label == 'Add') {
$save['name'] = 'add';
} elseif ($save_label == 'Modify') {
$save['name'] = 'edit';
}
$cancel = array(
'name' => 'cancel',
'label_key' => 'Cancel',
);
!empty($save_label) ? $buttons[] = $save : '';
if (!empty($morebuttons)) {
$buttons[] = $morebuttons;
}
//!empty($cancel_label) ? $buttons[] = $cancel : '';
$retstring = $withoutdiv ? '' : '';
foreach ($buttons as $button) {
$addclass = empty($button['addclass']) ? '' : $button['addclass'];
$retstring .= '
';
}
if ($cancel_label == "Cancel") {
$retstring .= '
' . $langs->trans($cancel['label_key']) . ' ';
}
$retstring .= $withoutdiv ? '' : '
Átadó adatai Átvevő adatai
';
$result .= '' . $UserInvoice['creatorlastname'] . ' ' . $UserInvoice['creatorfirstname'] . ' - ' . $UserInvoice['creatorlogin'] . ' ' . $UserInvoice['lastname'] . ' ' . $UserInvoice['firstname'] . ' - ' . $UserInvoice['userlogin'] . '
';
$result .= '
';
$result .= '';
$result .= 'Jutalék összege / Amount of commission: ' . number_format($UserInvoice['amount'], 0, '.', ' ') . ' Jutalék pénznem / Amount of currency: ' . $currencies[$UserInvoice['currency']] . '
';
$result .= '
';
$result .= 'Budapest, Bajcsy-Zsilinszky út 17, 1065
';
$result .= '' . $UserInvoice['paymentdate'] . '
';
$result .= '
';
$result .= '';
$result .=
'
_________________________________
_________________________________
Átadó aláírása
Átvevő aláírása
';
return $result;
}
function createHTMLForSettlement($dataArray)
{
$result = '
Jutalék / Commisson
Name of group
' . $dataArray['GroupName'] . '
Interval
' . $dataArray['Interval'] . '
Total amount
' . $dataArray['FullAmount'] . ' HUF
Data of Users
';
$result .= '
';
foreach ($dataArray['UsersData'] as $userdata) {
$result .= 'User: ' . $userdata['namedata'] . ' Amount: ' . $userdata['amount'] . ' HUF Invoices: ' . $userdata['invoices'] . '
';
return $result;
}
function checkinterval($db)
{
$id = GETPOST('id', 'int');
$interval_startyear = GETPOST('interval_startyear', 'int');
$interval_startmonth = GETPOST('interval_startmonth', 'int');
$interval_startday = GETPOST('interval_startday', 'int');
$interval_starthour = GETPOST('interval_starthour', 'int');
$interval_startmin = GETPOST('interval_startmin', 'int');
$interval_startsec = GETPOST('interval_startsec', 'int');
$interval_endyear = GETPOST('interval_endyear', 'int');
$interval_endmonth = GETPOST('interval_endmonth', 'int');
$interval_endday = GETPOST('interval_endday', 'int');
$interval_endhour = GETPOST('interval_endhour', 'int');
$interval_endmin = GETPOST('interval_endmin', 'int');
$startdate = $interval_startyear . '-' . $interval_startmonth . '-' . $interval_startday . ' ' . $interval_starthour . ':' . $interval_startmin . ':' . $interval_startsec;
$enddate = $interval_endyear . '-' . $interval_endmonth . '-' . $interval_endday . ' ' . $interval_endhour . ':' . $interval_endmin . ':59';
if ($id) {
$sql = "SELECT *
FROM " . MAIN_DB_PREFIX . "financialreport_commissioninterval
WHERE rowid <> {$id}
AND '{$startdate}' BETWEEN interval_start AND interval_end
OR rowid <> {$id} AND '{$enddate}' BETWEEN interval_start AND interval_end
";
$result = $db->query($sql);
return $db->num_rows($result) != 0;
} else {
$sql = "SELECT *
FROM " . MAIN_DB_PREFIX . "financialreport_commissioninterval
WHERE
'{$startdate}' BETWEEN interval_start AND interval_end
OR '{$enddate}' BETWEEN interval_start AND interval_end
";
$result = $db->query($sql);
if ($result) {
return $db->num_rows($result) != 0;
} else {
return false;
}
}
}
public function getEntities($entitiesArrayIsEmpty = false, $entities, $entitiesArray)
{
if ($entitiesArrayIsEmpty) {
$array = [];
foreach ($entities as $key => $value) {
$array[] = $key;
}
$selectedEntities = implode(', ', $array);
} else {
$array = [];
foreach ($entitiesArray as $entity) {
if ($entity)
$array[] = $entity;
}
$selectedEntities = implode(', ', $array);
}
return $selectedEntities;
}
function getAllGroupsFromGroupClass($selectedEntities)
{
global $db;
$groups = [];
$sql = "SELECT rowid, ref FROM " . MAIN_DB_PREFIX . "settlements_group WHERE hotelgroup IS NULL ";
if ($selectedEntities != '') {
$sql .= " AND fk_entity IN ({$selectedEntities})";
}
$sql .= "ORDER BY ref ASC";
$data = $db->query($sql);
if (!$data) {
dol_syslog("No group found.", LOG_DEBUG | LOG_INFO | LOG_WARNING | LOG_ERR);
setEventMessage('A csoport tábla lekérdezése sikertelen volt.', 'errors');
return $groups;
}
while ($row = pg_fetch_assoc($data)) {
$groups[$row['rowid']] = $row['ref'];
}
return $groups;
}
function getAllHotelGroupsFromGroupClass($db)
{
$groups = [];
$sql = "SELECT g.rowid, g.ref, g.fk_entity, gh.fk_hotel_id
FROM " . MAIN_DB_PREFIX . "settlements_group AS g
INNER JOIN " . MAIN_DB_PREFIX . "settlements_grouphotels as gh ON gh.fk_group_id = g.rowid
WHERE g.hotelgroup IS NOT NULL ORDER BY ref ASC";
//$sql = "SELECT rowid, ref, fk_entity FROM " . MAIN_DB_PREFIX . "settlements_group WHERE hotelgroup IS NOT NULL ORDER BY ref ASC";
//print $sql;exit;
$data = $db->query($sql);
if (!$data) {
dol_syslog("No group found.", LOG_DEBUG | LOG_INFO | LOG_WARNING | LOG_ERR);
setEventMessage('A csoport tábla lekérdezése sikertelen volt.', 'errors');
return $groups;
}
while ($row = pg_fetch_assoc($data)) {
$groups[$row['rowid']] = ["ref" => $row['ref'], "entity" => $row['fk_entity'], "fk_hotel_id" => $row['fk_hotel_id']];
}
return $groups;
}
function getGroupHotels()
{
global $db;
$groupHotels = [];
$sql = "SELECT gh.fk_group_id, gh.fk_hotel_id, g.ref as groulabel, h.label as hotellabel FROM " . MAIN_DB_PREFIX . "settlements_grouphotels AS gh
INNER JOIN " . MAIN_DB_PREFIX . "settlements_group AS g ON g.rowid = gh.fk_group_id
INNER JOIN " . MAIN_DB_PREFIX . "settlements_hotel AS h ON h.rowid = gh.fk_hotel_id
ORDER BY h.label ASC";
$data = $db->query($sql);
while ($row = pg_fetch_assoc($data)) {
$groupHotels[] = $row;
}
return $groupHotels;
}
function getUsersByIdWithDateCol2($db, $id, $date)
{
$usersOfGroup = [];
$date = date('Y-m-d', strtotime("-20 day", strtotime($date)));
/* $sqlLastLogin = "SELECT date_creation FROM llx_settlements_usernaplo WHERE status = 1 AND user_id = $id ORDER BY date_creation DESC LIMIT 1";
$result = $db->query($sqlLastLogin);
if($db->num_rows($result) > 0){
while($row = $db->fetch_object($result)){
$date = $row->date_creation;
}
}else{
$date = date('Y-m-d', strtotime("-20 day", dol_now()));
$date = $date . ' 00:00:00';
} */
$dateNow = date('Y-m-d H:i:s', dol_now());
if (isset($id)) {
$sql = "SELECT un.user_id, u.firstname as firstname, u.lastname as lastname, u.login as login FROM " . MAIN_DB_PREFIX . "settlements_usernaplo AS un
INNER JOIN " . MAIN_DB_PREFIX . "user as u ON u.rowid = un.user_id
WHERE un.group_user_id = {$id} AND un.date_creation BETWEEN '{$date} 00:00:00' AND '{$dateNow}' AND un.status = 1
GROUP BY un.user_id, u.firstname, u.lastname, u.login ORDER BY u.lastname";
$data = $db->query($sql);
if (!$data) {
dol_syslog("No data found.", LOG_DEBUG | LOG_INFO | LOG_WARNING | LOG_ERR);
setEventMessage('A csoporthoz rendelt felhasználók naplózási lekérdezésébe valami hiba csúszott.', 'errors');
return $usersOfGroup;
}
while ($row = pg_fetch_assoc($data)) {
$usersOfGroup[] = $row;
}
}
return $usersOfGroup;
}
/**
* @param int $id Group ID
*/
function getUsersByIdWithDate($db, $id, $date)
{
$usersOfGroup = [];
$date = date('Y-m-d', strtotime("-20 day", strtotime($date)));
$dateNow = date('Y-m-d H:i:s', dol_now());
if (isset($id)) {
$sql = "SELECT un.user_id, u.firstname as firstname, u.lastname as lastname, u.login as login, un.date_creation FROM " . MAIN_DB_PREFIX . "settlements_usernaplo AS un
INNER JOIN " . MAIN_DB_PREFIX . "user as u ON u.rowid = un.user_id
WHERE un.group_user_id = {$id} AND un.date_creation BETWEEN '{$date} 00:00:00' AND '{$dateNow}' AND un.status = 1
GROUP BY un.user_id, u.firstname, u.lastname, u.login, un.date_creation ORDER BY u.lastname";
//print $sql.' ' : '';
}
private function getBgColor($amount)
{
return $amount < 0 ? 'red' : 'green';
}
function tableDrawer($allSalesUsers, $db, $idmenu, $payment_type)
{
$rownum = 0;
foreach ($allSalesUsers as $user) {
$url = '/custom/financialreport/userinvoice_list.php?user_id=' . $user['rowid'] . '&idmenu=' . $idmenu . '&payment_type=' . $payment_type . '&mainmenu=financialreport&leftmenu=';
$bgcolor = $this->setRowColor($rownum);
print '
' . $user['lastname'] . ' ' . $user['firstname'] . ' ' . $user['nickname'] . ' ';
print '' . $user['login'] . ' ';
$this->drawCurrentBalance($user['rowid']);
$this->drawPayedRows($user['rowid'], $payment_type);
print ' ';
$rownum++;
}
}
function tableDrawerForBasicCommission($allSalesUsers, $db, $idmenu, $year, $month)
{
global $langs;
$rownum = 0;
$percentage = 0;
$commmissionhandler = new CommissionHandler();
foreach ($allSalesUsers as $user) {
$amountHUF = $commmissionhandler->getCommisonByUserIdForAMonth($user['rowid'], $year, $month);
$amount = $amountHUF;
$userCommissionMinimumAmount = $commmissionhandler->getUserMinimumCommission($user['rowid']);
$suplement = $userCommissionMinimumAmount - $amount < 0 ? 0 : $userCommissionMinimumAmount - $amount;
$bgcolor = $this->setRowColor($rownum);
$percentage = $this->getPercentage($userCommissionMinimumAmount, $amount);
$amountcolor = $amount < $userCommissionMinimumAmount ? 'red' : 'lightgreen';
$fontcolor = $percentage < 4 || $amount >= $userCommissionMinimumAmount ? 'black' : 'white';
$makeUpToValue = $user['rowid'] . '|' . $suplement . '|' . $year . '|' . $month . '|' . $user['lastname'] . ' ' . $user['firstname'];
$buttondisplay = $suplement > 0 ? 'style="display:block;"' : 'style="display:none;"';
$makeUpToButton = strtotime($year . '-' . $month) < strtotime(date('Y-m')) ? '
' . $langs->trans('MakeUpTo') . '
' : ' ';
//$url = '/custom/financialreport/userinvoicebasiccommission_list.php?user_id=' . $user['rowid'] . '&idmenu=' . $idmenu . '&mainmenu=financialreport&leftmenu=';
print '';
print '' . $user['lastname'] . ' ' . $user['firstname'] . ' ' . $user['nickname'] . ' ';
print '' . $this->correctNumber($userCommissionMinimumAmount) . ' HUF ';
print '' . $this->correctNumber($suplement) . ' HUF ';
print ' ' . $this->correctNumber($amount) . ' HUF
';
$rownum++;
}
}
function getPercentage($minAmount, $amount)
{
if ($minAmount != 0) {
$percentage = ($amount / $minAmount) * 100;
if ($percentage > 100) {
$percentage = 100;
}
} else {
$percentage = $amount == 0 ? 0 : 100;
}
return $percentage;
}
private function drawCurrentBalanceForTpls($amount, $currency)
{
global $langs;
$color = $this->getBgColor($amount);
print '
' . $langs->trans("CurrentBalance") . ' ' . $currency . '
' . number_format($amount, 0, '.', ' ') . ' ' . $currency . '
';
}
private function drawMinimumCommissionForTpls($amount, $currency)
{
global $langs;
$color = $this->getBgColor($amount);
print '
' . $langs->trans("MinimumCommission") . ' ' . $currency . '
' . number_format($amount, 0, '.', ' ') . ' ' . $currency . '
';
}
function tableDrawerForViewTpls($user_id, $db, $userData, $payment_type)
{
global $langs;
print '' . $userData->firstname . ' ' . $userData->lastname . '
';
print '
';
$balance = $this->getFullBalance($user_id, $db);
$earlierCommissionHUF = $balance[0]['amount'] == null ? 0 : $balance[0]['amount'];
print '';
$this->drawCurrentBalanceForTpls($earlierCommissionHUF, 'HUF');
$amounts = $this->getAllPaymenttype($user_id, $db, $payment_type);
foreach ($amounts as $amount) {
print '
' . $this->getViewTplTitle($payment_type) . ' ' . $amount['type'] . '
' . number_format($amount['amount'], 0, '.', ' ') . ' ' . $amount['type'] . '
';
}
print '
';
$minimumCommission = $this->getminimumCommissionGorUser($user_id);
print '';
$this->drawMinimumCommissionForTpls($minimumCommission, 'HUF');
print '
';
}
}
private function getminimumCommissionGorUser($user_id)
{
global $langs, $db;
$userObj = new User($this->db);
$sql = "SELECT * FROM llx_user as u INNER JOIN llx_user_extrafields as ue ON ue.fk_object = u.rowid WHERE u.rowid = {$user_id}";
$result = $db->query($sql);
while($row = $db->fetch_object($result)){
$minimum_monthly_commission = $row->minimum_monthly_commission;
}
if (!$result) {
dol_syslog("No data found.", LOG_DEBUG | LOG_INFO | LOG_WARNING | LOG_ERR);
setEventMessage($langs->trans('noUserForMinimumCommission'), 'errors');
}
return $minimum_monthly_commission;
}
private function setRowColor($rownum)
{
return $rownum % 2 == 0 ? '#b0c4de' : 'white';
}
private function drawCurrentBalance($user_id)
{
$balance = $this->getFullBalance($user_id, $this->db);
if (isset($ammount[0])) {
$earlierCommissionHUF = $balance[0]['amount'] == null ? 0 : $balance[0]['amount'];
} else {
$earlierCommissionHUF = 0;
}
$earlierCommissionHUF = $balance[0]['amount'] == null ? 0 : $balance[0]['amount'];
//$earlierCommissionEUR = $balance[1]['amount'] == null ? 0 : $balance[1]['amount'];
$warning = $this->isWarning($earlierCommissionHUF);
print '' . number_format($earlierCommissionHUF, 0, '.', ' ') . ' HUF ' . $warning . ' ';
/* $warning = $this->isWarning($earlierCommissionEUR);
print '' . number_format($earlierCommissionEUR, 0, '.', ' ') . ' EUR ' . $warning . ' '; */
}
private function drawPayedRows($user_id, $payment_type)
{
$amounts = $this->getAllPaymenttype($user_id, $this->db, $payment_type);
foreach ($amounts as $amount) {
print '' . number_format($amount['amount'], 0, '.', ' ') . ' ' . $amount['type'] . ' ';
}
}
function tableDrawerForHistory($allSalesUsers, $idmenu)
{
$rownum = 0;
foreach ($allSalesUsers as $user) {
$url = '/custom/financialreport/commissionhistory_list.php?user_id=' . $user['rowid'] . '&idmenu=' . $idmenu . '&payment_type=2&mainmenu=financialreport&leftmenu=';
$bgcolor = $this->setRowColor($rownum);
print '
' . $user['lastname'] . ' ' . $user['firstname'] . ' ' . $user['nickname'] . ' ';
print '' . $user['login'] . ' ';
// Itt azt kell megejelníteni, ami a még ki nem fizetett jutalékokból és a kifizetett előlegek és visszatartsások összegének különbségéből áll össze.
$this->drawCurrentBalance($user['rowid']);
$this->drawPayedRows($user['rowid'], 2);
$this->drawPayedRows($user['rowid'], 0);
print ' ';
$rownum++;
}
}
function tableDrawerForDailyClosing($allSalesUsers, $idmenu)
{
$rownum = 0;
foreach ($allSalesUsers as $user) {
$url = '/custom/settlements/dailyclosing_card.php?user_id=' . $user['rowid'] . '&idmenu=' . $idmenu . '&mainmenu=settlements&leftmenu=';
$bgcolor = $this->setRowColor($rownum);
print '
' . $user['lastname'] . ' ' . $user['firstname'] . ' ' . $user['nickname'] . ' ';
print '' . $user['login'] . ' ';
// Itt azt kell megejelníteni, ami a még ki nem fizetett jutalékokból és a kifizetett előlegek és visszatartsások összegének különbségéből áll össze.
$this->drawCurrentBalance($user['rowid']);
$this->drawPayedRows($user['rowid'], 2);
$this->drawPayedRows($user['rowid'], 0);
print ' ';
$rownum++;
}
}
function generateRef($payment_type)
{
return $this->getTypeOfPayment($payment_type) . '_' . dol_now() . '_' . rand(1000000, 9999999);
}
/* function checkBalance($user_id, $date)
{
$sql = "SELECT invoices FROM " . MAIN_DB_PREFIX . "financialreport_userinvoice
WHERE user_id = {$user_id}
AND date_creation BETWEEN '{$date} 00:00:00' AND '{$date} 23:59:59'
AND payment_type = 2
";
$resultBalanceData = $this->db->query($sql);
$result = pg_fetch_all($resultBalanceData);
return is_array($result);
} */
function getOccassionOfThisPeriodByDateAndUserId($user_id, $from, $to)
{
return rand(100, 1000);
}
function createDataArrayForLoginLogotOccassionTable($results)
{
$array = [];
$i = 0;
foreach ($results as $record) {
if ($record->login_logout_status == 0) {
$array[$i]['login'] = date('Y-m-d H:i:s', $record->date_creation);
} else {
if (isset($record->date_creation)) {
$array[$i]['logout'] = date('Y-m-d H:i:s', $record->date_creation);
}
}
$i++;
}
return $array;
}
function createUserDataArray($array, $userOfGroups)
{
$userDataArray = [];
$count = count($array);
for ($k = 0; $k < $count; $k++) {
if (isset($array[$k]['login'])) {
if (!isset($userDataArray[$k - 1]['logout']) && $k != 0) {
$userDataArray[$k - 1]['logout'] = $array[$k]['login'] . '*';
}
$userDataArray[$k]['login'] = $array[$k]['login'];
}
if (isset($array[$k]['logout'])) {
$userDataArray[$k - 1]['logout'] = $array[$k]['logout'];
}
if ($k == $count - 1 && isset($deletedUsersArray[$userOfGroups['user_id']])) {
$userDataArray[$k]['logout'] = $array[$userOfGroups['user_id']];
}
}
return $userDataArray;
}
function updateUserDataArray($userDataArray, $deletedUsersArray, $userOfGroups, $commmissionhandler)
{
foreach ($userDataArray as $key => $period) {
$from = $period['login'];
$to = isset($period['logout']) ? $period['logout'] : (isset($deletedUsersArray[$userOfGroups['user_id']]) ? $deletedUsersArray[$userOfGroups['user_id']] : date('Y-m-d', dol_now()) . ' 23:59:59');
print $from . ' - ' . $to . '' . $row['firstname'] . ' ' . $row['lastname'] . ' (' . $this->userCategoryArray[$row['user_category']] . ') ' . $this->correctNumber($this->getAllAmountInPeriod($id, $daterange, 'HUF', $row['rowid'], $entity)) . ' HUF ' . $this->correctNumber($this->getAllAmountInPeriod($id, $daterange, 'EUR', $row['rowid'], $entity)) . ' EUR