Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
api	[ DIR ]	drwxrwxrwx
assets	[ DIR ]	drwxrwxrwx
docs	[ DIR ]	drwxrwxrwx
img	[ DIR ]	drwxrwxrwx
img-clients	[ DIR ]	drwxrwxrwx
img-dept	[ DIR ]	drwxrwxrwx
img-empl	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
src	[ DIR ]	drwxrwxrwx
upload_docs	[ DIR ]	drwxrwxrwx
.ftpquota	14 B	-rwxr-xr-x
account_heads.php	5.56 KB	-rwxr-xr-x
agents.php	4.38 KB	-rwxr-xr-x
agents_save.php	8.31 KB	-rwxr-xr-x
attendance.php	2.83 KB	-rwxr-xr-x
attendance_report.php	7.45 KB	-rwxr-xr-x
attendance_report_excel.php	14.66 KB	-rw-rw-r--
control.php	8.22 KB	-rwxr-xr-x
departments.php	18.14 KB	-rwxr-xr-x
documents.php	10 KB	-rwxr-xr-x
documents_form.php	3.64 KB	-rwxr-xr-x
documents_grid.php	1.14 KB	-rwxr-xr-x
employees.php	1.08 KB	-rwxr-xr-x
employees_form.php	18.18 KB	-rwxr-xr-x
employees_grid.php	2.75 KB	-rwxr-xr-x
expense.php	3.35 KB	-rwxr-xr-x
expense_advance.php	7.38 KB	-rwxr-xr-x
expense_advance2.php	7.85 KB	-rw-rw-r--
expense_report.php	8.1 KB	-rwxr-xr-x
expense_report_summary.php	2.16 KB	-rwxr-xr-x
header.php	7.52 KB	-rwxr-xr-x
holidays.php	6.66 KB	-rwxr-xr-x
index.css	1.67 KB	-rw-rw-r--
index.html	4.69 KB	-rw-rw-r--
index11.08.2020.html	3.08 KB	-rwxr-xr-x
index19.04.2019.html	2.32 KB	-rwxr-xr-x
index27.05.2021.css	1.62 KB	-rwxr-xr-x
index27.05.2021.html	2.58 KB	-rwxr-xr-x
indexdir.php	2.82 KB	-rwxr-xr-x
items.php	5.11 KB	-rwxr-xr-x
itemstype.php	4.51 KB	-rwxr-xr-x
mainpage.php	2.88 KB	-rwxr-xr-x
mainpage19.04.2019.php	2.49 KB	-rwxr-xr-x
mc_print.php	7.15 KB	-rwxr-xr-x
messages.php	4.1 KB	-rwxr-xr-x
password_request.php	1.49 KB	-rwxr-xr-x
pg_app_edit.php	29.3 KB	-rwxr-xr-x
reminders.php	7.81 KB	-rwxr-xr-x
salary.php	3.18 KB	-rwxr-xr-x
salary_statement.php	3.77 KB	-rw-rw-r--
send_mail.php	3.58 KB	-rwxr-xr-x
send_sms.php	2.49 KB	-rwxr-xr-x
staff_move.php	11.7 KB	-rwxr-xr-x
style.css	16.12 KB	-rwxr-xr-x
style08.07.2020.css	14.33 KB	-rwxr-xr-x
style19.04.2019.css	12.65 KB	-rwxr-xr-x
task_reminder.php	1.09 KB	-rwxr-xr-x
task_reminder_form.php	4.72 KB	-rwxr-xr-x
task_reminder_grid.php	2.86 KB	-rwxr-xr-x
task_reminder_old.php	11.43 KB	-rwxr-xr-x
task_review.php	7.75 KB	-rwxr-xr-x
task_update.php	7.63 KB	-rwxr-xr-x
upcoming_events.php	3.12 KB	-rw-rw-r--
user_departments.php	3.63 KB	-rwxr-xr-x
user_logs.php	3.84 KB	-rwxr-xr-x
user_password.php	4.09 KB	-rwxr-xr-x
user_password_change.php	1.83 KB	-rwxr-xr-x
user_password_request.php	1.19 KB	-rwxr-xr-x
user_password_request13.12.202...	1.61 KB	-rwxr-xr-x
user_rights.php	2.96 KB	-rwxr-xr-x
user_setup.php	9.86 KB	-rwxr-xr-x
work_assign.php	1.13 KB	-rw-rw-r--
work_assign_form.php	4.84 KB	-rw-rw-r--
work_assign_grid.php	3.76 KB	-rw-rw-r--
work_entry.php	1.13 KB	-rwxr-xr-x
work_entry_form.php	8.02 KB	-rwxr-xr-x
work_entry_form_org.php	1.48 KB	-rwxr-xr-x
work_entry_grid.php	3.21 KB	-rwxr-xr-x
work_entry_report.php	4.01 KB	-rwxr-xr-x
work_review.php	14.09 KB	-rwxr-xr-x

Code Editor : expense_advance.php

<!DOCTYPE html>
<html>

<div id="page-container-body" class="panel-body">
                <div id="page-container-main">
                    <table style="width:100%;">
                        <tr>
                            <td style="width:40%;">
                                <?php
                                echo "<select class='form-input' id='selemplcode' onChange='load_grid_data(20,1);'>";
                                if ($type_id == 'ADMIN') {
                                    $mysql = "select distinct em.femplcode,femplname from masempl em
                                    inner join expenses_advance ex on em.femplcode = ex.femplcode
                                    order by femplname;";
                                } else {
                                    $mysql = "select * from masempl where femplcode='$empl_id' order by femplname";
                                }
                                $myres = mysqli_query($mycon, $mysql);
                                if (mysqli_num_rows($myres) > 1) {
                                    echo "<option value='%%'>ALL [EMPLOYEES]</option>";
                                }

while ($myrow = mysqli_fetch_assoc($myres)) {
                                    echo "<option value='$myrow[femplcode]'>$myrow[femplname] [$myrow[femplcode]]</option>";
                                }
                                echo "</select>";
                                ?>
                            </td>
                            <td style="width:30%;">
                                <?php
                                echo "<select class='form-input' id='seladvnmnth' onChange='load_grid_data(20,1);'>";
                                $mysql = "select date_format(fadvndate,'%Y-%m') as fadvnmnth,date_format(fadvndate,'%Y %M') as fdispmnth from expenses_advance 
                                group by date_format(fadvndate,'%Y-%m') order by fadvndate desc";
                                $myres = mysqli_query($mycon, $mysql);
                                while ($myrow = mysqli_fetch_assoc($myres)) {
                                    echo "<option value='$myrow[fadvnmnth]'>$myrow[fdispmnth]</option>";
                                }
                                if (mysqli_num_rows($myres) > 1) {
                                    echo "<option value='%'>ALL [MONTHS]</option>";
                                }
                                echo "</select>";
                                ?>
                            </td>
                            <td style="width:30%;">
                                <input type="text" id="txtadvnfind" class="form-input" onInput="load_grid_data(20,1);" placeholder="Search expense advance details..">
                            </td>
                        </tr>
                    </table>
                </div>

<div class="panel panel-primary" style="width:1024px;margin-left:auto;margin-right:auto;">
                        <div class="panel-heading">Advance Details</div>
                        <div class="panel-body" style="position: relative;">
                            <div class="form-group">
                                <label for="" class="col-sm-2 control-label">Advance Month</label>
                                <div class="col-sm-2">
                                    <input type="text" class="form-control text-center text-uppercase" id="txtadvndate" maxlength="7" />
                                </div>
                            </div>

<div class="form-group">
                                <label for="" class="col-sm-2 control-label">Employee</label>
                                <div class="col-sm-9">
                                    <?php
                                    $myqry = "";
                                    if ($type_id == 'ADMIN') {
                                        $myqry = "";
                                    } else{
                                        $myqry = " and femplcode ='$empl_id' ";
                                    }

echo "<select class='form-input' id='txtemplcode'>";
                                    $mysql = "select * from masempl where femplstat='T' and fexpnentr='T' and fdeleted<>'T' " . $myqry . " order by femplname;";
                                    $myres = mysqli_query($mycon, $mysql);
                                    if (mysqli_num_rows($myres) > 1) {
                                        echo "<option value=''>--SELECT--</option>";
                                    }
                                    while ($myrow = mysqli_fetch_assoc($myres)) {
                                        echo "<option value='$myrow[femplcode]'>$myrow[femplname]</option>";
                                    }
                                    echo "</select>";
                                    ?>
                                </div>
                            </div>

<div class="form-group">
                                <label for="" class="col-sm-2 control-label">Description</label>
                                <div class="col-sm-9">
                                    <input type="text" class="form-control" id="txtadvndesc" maxlength="100" placeholder="Desciption" />
                                </div>
                            </div>

<div class="form-group">
                                <label for="" class="col-sm-2 control-label">Amount</label>
                                <div class="col-sm-2">
                                    <input type="text" class="form-control text-right" id="txtadvnamnt" value="0.00" maxlength="10" placeholder="Amount" />
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>

</html>

${this.title}

Code Editor : expense_advance.php