#!/usr/bin/php
connected <br> sfa_source_conn<br>--currentYear--2025<br>--currentMonth--12currentMonth: 12<br>--Month--12<br>--YearMonth--202512<br>startdate2025-12-01<br>enddate2025-12-31<br/>---- Insert user Master Start Time ---2025-12-06 10:34:31INSERT INTO user_master(login_id,user_password,first_name,middle_name,last_name,employee_code,joining_date,email,created_on)
SELECT user_name,user_password,first_name,middle_name,last_name,employeecode,joining_date,email1,creation_date
FROM users
WHERE deleted=0 and status='Active' and user_name != 'VACANT' 
and user_name not in (SELECT login_id FROM user_master where deleted=0 and resigned=0)<br/>---- End Time ---2025-12-06 10:34:31<br>--affected rows--0<br/>---- Start Time ---2025-12-06 10:34:31INSERT INTO patches_master(patchid,patchsapcode,patchname,sap_territoryname,hqid,cityid,stateid,zoneid,districtid,
        division,patch_deleted,creation_date,deletion_date,patches_updated_by,patches_updated_date,areaid,t1,v_date,sap_hq_name,
        role_id,profile_id,designation,month,year)
        SELECT p1.* FROM (
        SELECT patchid,patchsapcode,patchname,'',hqid,cityid,stateid,zoneid,districtid,patches.division,patch_deleted,
        patches.creation_date,patches.deletion_date,patches_updated_by,patches_updated_date,areaid,t1,v_date,hq_unique_code,
        user2role.roleid,role2profile.profileid,users.title,'12' as month,'2025' as year 
        FROM patches
        INNER JOIN users on users.patch =patches.patchid
        INNER JOIN user2role on user2role.userid = users.id
        INNER JOIN role2profile on role2profile.roleid = user2role.roleid
        WHERE patches.patch_deleted=0 and users.deleted=0
        ORDER BY patchid)p1
        LEFT OUTER JOIN patches_master on patches_master.patchid = p1.patchid and patches_master.month='12' and patches_master.year='2025'
        WHERE  patches_master.id is null<br/>---- End Time ---2025-12-06 10:34:31<br>--affected rows--0<br/>---- Start Time ---2025-12-06 10:34:31INSERT INTO patches_master(patchid,patchname,patch_deleted,creation_date,role_id,profile_id,designation,month,year)
SELECT CASE
    WHEN title ='SALESADMIN' THEN '900000001'
    ELSE ''
END as patchid,title as patchname,'0' as patch_deleted ,NOW() as creation_date,5 as role_id,1 as profile_id,title as designation,'12' as month,'2025' as year
FROM users
WHERE title in ('SALESADMIN','SFE','Executive Director') and CASE
    WHEN title ='SALESADMIN' THEN '900000001'
    ELSE ''
END  NOT IN (SELECT patchid FROM patches_master where patchid in (900000001) and month='12' and year='2025');<br/>---- End Time ---2025-12-06 10:34:31<br>--affected rows--0<br/>---- Start Time ---2025-12-06 10:34:31UPDATE patches_master
SET patchsapcode = patchid
WHERE month='12' and year ='2025' and profile_id !=5;<br/>---- Start Time ---2025-12-06 10:34:31DROP TABLE If EXISTS emp_history;<br/>---- End Time ---2025-12-06 10:34:32<br>--affected rows--0<br/>---- Start Time ---2025-12-06 10:34:32CREATE TABLE  emp_history
SELECT usersbefore_newjoin.pid,usersbefore_newjoin.division,user_master.id as employee_id,usersbefore_newjoin.id,usersbefore_newjoin.patch,
usersbefore_newjoin.user_name,usersbefore_newjoin.first_name,usersbefore_newjoin.last_name,usersbefore_newjoin.reports_to_id,
usersbefore_newjoin.joining_date,usersbefore_newjoin.terr_joining_date,usersbefore_newjoin.title,usersbefore_newjoin.resign_date,
usersbefore_newjoin.moved_date,usersbefore_newjoin.reasonformove 
FROM usersbefore_newjoin
INNER JOIN user_master on user_master.login_id = usersbefore_newjoin.user_name
WHERE usersbefore_newjoin.resign_date>='2025-12-01' and reasonformove in (1,2,9)
ORDER BY usersbefore_newjoin.user_name,usersbefore_newjoin.pid<br/>---- End Time ---2025-12-06 10:34:34<br>--affected rows--0<br/>---- Start Time ---2025-12-06 10:34:34INSERT INTO emp_history (division,employee_id,id,patch,user_name,first_name,last_name,reports_to_id,joining_date,
terr_joining_date,title,resign_date,moved_date,reasonformove)
SELECT if(users.division is null,0,users.division) as division,user_master.id as employee_id,users.id,users.patch,users.user_name,
users.first_name,users.last_name,users.reports_to_id,users.joining_date,users.terr_joining_date,users.title,'0000-00-00','0000-00-00','0' 
FROM users
INNER JOIN user_master on user_master.login_id = users.user_name
ORDER BY users.user_name<br />
<b>Fatal error</b>:  Uncaught mysqli_sql_exception: Table 'brintonsaleslive.emp_history' doesn't exist in /var/www/html/Brinton/scripts/territory_master_new.php:152
Stack trace:
#0 /var/www/html/Brinton/scripts/territory_master_new.php(152): mysqli_query()
#1 {main}
  thrown in <b>/var/www/html/Brinton/scripts/territory_master_new.php</b> on line <b>152</b><br />