__ __ __ __ _____ _ _ _____ _ _ _
| \/ | \ \ / / | __ \ (_) | | / ____| | | | |
| \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | |
| |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | |
| | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | |
|_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1
if you need WebShell for Seo everyday contact me on Telegram
Telegram Address : @jackleet
For_More_Tools:
<?php
require_once 'ProgramFunctions/FileUpload.fnc.php';
require_once 'modules/Accounting/functions.inc.php';
if ( User( 'PROFILE' ) === 'teacher' ) //limit to teacher himself
{
$_REQUEST['staff_id'] = User( 'STAFF_ID' );
}
if ( empty( $_REQUEST['print_statements'] ) )
{
DrawHeader( ProgramTitle() );
Search( 'staff_id', issetVal( $extra ) );
}
// Add eventual Dates to $_REQUEST['values'].
AddRequestedDates( 'values', 'post' );
if ( ! empty( $_REQUEST['values'] )
&& $_POST['values']
&& AllowEdit()
&& UserStaffID() )
{
foreach ( (array) $_REQUEST['values'] as $id => $columns )
{
if ( $id !== 'new' )
{
$columns['FILE_ATTACHED'] = _savePaymentsFile( $id );
if ( ! $columns['FILE_ATTACHED'] )
{
unset( $columns['FILE_ATTACHED'] );
}
DBUpdate(
'accounting_payments',
$columns,
[ 'STAFF_ID' => UserStaffID(), 'ID' => (int) $id ]
);
}
elseif ( isset( $columns['AMOUNT'] )
&& is_numeric( $columns['AMOUNT'] )
&& $columns['PAYMENT_DATE'] )
{
$insert_columns = [
'STAFF_ID' => UserStaffID(),
'SYEAR' => UserSyear(),
'SCHOOL_ID' => UserSchool(),
];
$columns['FILE_ATTACHED'] = _savePaymentsFile( $id );
DBInsert(
'accounting_payments',
$insert_columns + $columns
);
}
}
// Unset values & redirect URL.
RedirectURL( 'values' );
}
if ( $_REQUEST['modfunc'] === 'remove'
&& AllowEdit() )
{
if ( DeletePrompt( _( 'Payment' ) ) )
{
$file_attached = DBGetOne( "SELECT FILE_ATTACHED
FROM accounting_payments
WHERE ID='" . (int) $_REQUEST['id'] . "'" );
if ( ! empty( $file_attached )
&& file_exists( $file_attached ) )
{
// Delete File Attached.
unlink( $file_attached );
}
DBQuery( "DELETE FROM accounting_payments
WHERE ID='" . (int) $_REQUEST['id'] . "'" );
// Unset modfunc & ID & redirect URL.
RedirectURL( [ 'modfunc', 'id' ] );
}
}
if ( UserStaffID() && ! $_REQUEST['modfunc'] )
{
$payments_total = 0;
$functions = [
'REMOVE' => '_makePaymentsRemove',
'AMOUNT' => '_makePaymentsAmount',
'PAYMENT_DATE' => 'ProperDate',
'COMMENTS' => '_makePaymentsCommentsInput',
'FILE_ATTACHED' => '_makePaymentsFileInput',
];
$payments_RET = DBGet( "SELECT '' AS REMOVE,ID,AMOUNT,PAYMENT_DATE,COMMENTS,FILE_ATTACHED
FROM accounting_payments
WHERE STAFF_ID='" . UserStaffID() . "'
AND SYEAR='" . UserSyear() . "'
AND SCHOOL_ID='" . UserSchool() . "'
ORDER BY PAYMENT_DATE,ID", $functions );
$i = 1;
$RET = [];
foreach ( (array) $payments_RET as $payment )
{
$RET[$i] = $payment;
$i++;
}
$columns = [];
if ( ! empty( $RET )
&& empty( $_REQUEST['print_statements'] )
&& AllowEdit()
&& ! isset( $_REQUEST['_ROSARIO_PDF'] ) )
{
$columns = [ 'REMOVE' => '<span class="a11y-hidden">' . _( 'Delete' ) . '</span>' ];
}
$columns += [
'AMOUNT' => _( 'Amount' ),
'PAYMENT_DATE' => _( 'Date' ),
'COMMENTS' => _( 'Comment' ),
];
if ( empty( $_REQUEST['print_statements'] ) )
{
$columns += [ 'FILE_ATTACHED' => _( 'File Attached' ) ];
}
$link = [];
if ( empty( $_REQUEST['print_statements'] )
&& AllowEdit() )
{
$link['add']['html'] = [
'REMOVE' => button( 'add' ),
'AMOUNT' => _makePaymentsTextInput( '', 'AMOUNT' ),
'PAYMENT_DATE' => _makePaymentsDateInput( DBDate(), 'PAYMENT_DATE' ),
'COMMENTS' => _makePaymentsCommentsInput( '', 'COMMENTS' ),
'FILE_ATTACHED' => _makePaymentsFileInput( '', 'FILE_ATTACHED' ),
];
}
$options = [];
if ( empty( $_REQUEST['print_statements'] )
&& AllowEdit() )
{
echo '<form action="' . URLEscape( 'Modules.php?modname=' . $_REQUEST['modname'] . '&staff_id=' . UserStaffID() ) . '" method="POST">';
DrawHeader( '', SubmitButton() );
$options = [ 'valign-middle' => true ];
}
ListOutput( $RET, $columns, 'Payment', 'Payments', $link, [], $options );
if ( empty( $_REQUEST['print_statements'] )
&& AllowEdit() )
{
echo '<div class="center">' . SubmitButton() . '</div>';
}
echo '<br />';
$salaries_total = DBGetOne( "SELECT SUM(f.AMOUNT) AS TOTAL
FROM accounting_salaries f
WHERE f.STAFF_ID='" . UserStaffID() . "'
AND f.SYEAR='" . UserSyear() . "'
AND f.SCHOOL_ID='" . UserSchool() . "'" );
$table = '<table class="align-right accounting-staff-payroll-totals"><tr><td>' . _( 'Total from Salaries' ) . ': ' . '</td><td>' . Currency( $salaries_total ) . '</td></tr>';
$table .= '<tr><td>' . _( 'Less' ) . ': ' . _( 'Total from Staff Payments' ) . ': ' . '</td><td>' . Currency( $payments_total ) . '</td></tr>';
$table .= '<tr><td>' . _( 'Balance' ) . ': </td>
<td><b>' . Currency( ( $salaries_total - $payments_total ), 'CR' ) .
'</b></td></tr></table>';
DrawHeader( $table );
if ( empty( $_REQUEST['print_statements'] )
&& AllowEdit() )
{
echo '</form>';
}
}