-- MySQL dump 10.13  Distrib 8.0.44, for Linux (x86_64)
--
-- Host: localhost    Database: repayment
-- ------------------------------------------------------
-- Server version	8.0.44-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `log_activity`
--

DROP TABLE IF EXISTS `log_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_activity` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `USER_ID` int NOT NULL,
  `TYPE` varchar(100) NOT NULL,
  `KEY_ID` int NOT NULL,
  `MODULE` varchar(100) NOT NULL,
  `SOURCE` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_activity`
--

LOCK TABLES `log_activity` WRITE;
/*!40000 ALTER TABLE `log_activity` DISABLE KEYS */;
INSERT INTO `log_activity` VALUES (1,4,'INSERT',101,'Student List','student_code=>9999999999///student_name=>kriettipoom srijam///student_firstname=>kriettipoom///student_lastname=>srijam///student_curriculum=>6///student_type=>2///student_school=>6///student_nationality=>2///student_advisor=>4///student_degree=>Bachelor///student_email=>kriettipoom@siit.tu.ac.th///student_academicstatus=>1///student_end_date_student_status_siit=>///student_end_date_student_status=>///student_start_year=>24///student_end_year=>25///student_semester_from=>1///student_semester_to=>3///student_scholarship_program=>1///student_scholarship_status=>///student_agreement_no=>9999///student_agreement_date=>2025-07-09///student_guarantor_firstname=>Mr.Tide///student_guarantor_lastname=>MONICA///student_guarantor_email=>itide@mail.om///student_debt_status=>Active///student_outstanding_balance=>890000///student_outstanding_balance_payment=>2025-07-22///student_remark=>samodajukku///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>///','2025-07-22 10:32:51','2025-07-22 10:32:51'),(2,4,'UPDATE',101,'Student List','student_code=>9999999999///student_name=>kriettipoom srijam///student_firstname=>kriettipoom///student_lastname=>srijam///student_curriculum=>6///student_type=>2///student_school=>6///student_nationality=>2///student_advisor=>4///student_degree=>Bachelor///student_email=>kriettipoom@siit.tu.ac.th///student_academicstatus=>1///student_end_date_student_status_siit=>///student_end_date_student_status=>///student_start_year=>24///student_end_year=>25///student_semester_from=>1///student_semester_to=>3///student_scholarship_program=>1///student_scholarship_status=>///student_agreement_no=>9999///student_agreement_date=>2025-07-09///student_guarantor_firstname=>Mr.Tide///student_guarantor_lastname=>MONICA///student_guarantor_email=>itide@mail.om///student_debt_status=>Active///student_outstanding_balance=>890000///student_outstanding_balance_payment=>2025-07-22///student_remark=>samodajukkupaku///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>///','2025-07-22 10:33:17','2025-07-22 10:33:17'),(3,4,'INSERT',102,'Student List','student_code=>6130203639///student_name=>test_1 inst///student_firstname=>test_1///student_lastname=>inst///student_curriculum=>1///student_type=>1///student_school=>1///student_nationality=>1///student_advisor=>2///student_degree=>Bachelor///student_email=>Test_mail_1@hotmail.com///student_academicstatus=>1///student_end_date_student_status_siit=>///student_end_date_student_status=>///student_start_year=>24///student_end_year=>24///student_semester_from=>2///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>Doggy-200///student_agreement_date=>2025-07-22///student_guarantor_firstname=>Jugjug///student_guarantor_lastname=>Jigjig///student_guarantor_email=>guarantor1@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>45000///student_outstanding_balance_payment=>2025-07-09///student_remark=>xxxx///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>///','2025-07-23 14:53:31','2025-07-23 14:53:31'),(4,4,'INSERT',103,'Student List','student_code=>6130203639///student_name=>test_2 inst///student_firstname=>test_2///student_lastname=>inst///student_curriculum=>3///student_type=>2///student_school=>2///student_nationality=>2///student_advisor=>7///student_degree=>Bachelor///student_email=>Test_mail_2@hotmail.com///student_academicstatus=>1///student_end_date_student_status_siit=>///student_end_date_student_status=>///student_start_year=>23///student_end_year=>20///student_semester_from=>1///student_semester_to=>1///student_scholarship_program=>2///student_scholarship_status=>///student_agreement_no=>Panda-600///student_agreement_date=>2025-07-26///student_guarantor_firstname=>Jugjug4///student_guarantor_lastname=>Jigjig4///student_guarantor_email=>guarantor2@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>30000///student_outstanding_balance_payment=>2025-07-22///student_remark=>yyyy///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>///','2025-07-23 14:54:49','2025-07-23 14:54:49'),(5,4,'INSERT',63,'Set Loan','set_loan_tt_student=>102///set_loan_tt_rivision=>1///set_loan_tt_op_balance=>45000///set_loan_tt_no_status=>Active///set_loan_tt_no_inst_approved=>10///set_loan_tt_payment_date=>2025-01///set_loan_tt_interest_rate=>1///','2025-07-23 14:55:19','2025-07-23 14:55:19'),(6,4,'UPDATE',63,'Set Loan','set_loan_tt_paid_per_month=>4500///set_loan_tt_interest=>207.28///set_loan_tt_repayment=>45207.28///set_loan_tt_amount_paid=>9000.00///set_loan_tt_amount_interest=>36000///set_loan_tt_no_inst_paid=>10///set_loan_tt_no_inst_remain=>0///set_loan_tt_total_interest_in_rev=>207.28///set_loan_tt_total_payment_installment_in_rev=>44792.72///set_loan_tt_total_paid_per_month_for_cal_in_rev=>45000.00///set_loan_tt_op_balance_current=>36,071.28///set_loan_tt_op_balance_next=>207.28///set_loan_tt_table=>[{\"receipt_no\":\"a1\",\"receipt_date\":\"2025-07-01\",\"amount\":\"4500\"},{\"receipt_no\":\"a2\",\"receipt_date\":\"2025-07-16\",\"amount\":\"4500\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"}]///','2025-07-23 14:55:56','2025-07-23 14:55:56'),(7,4,'INSERT',23,'Set Scholarship','set_scholarship_tt_student=>103///set_scholarship_tt_rivision=>1///set_scholarship_tt_op_balance=>40000///set_scholarship_tt_no_status=>Active///set_scholarship_tt_no_inst_approved=>10///set_scholarship_tt_payment_date=>2025-01///set_scholarship_tt_interest_rate=>1///','2025-07-23 14:56:24','2025-07-23 14:56:24'),(8,4,'UPDATE',23,'Set Scholarship','set_scholarship_tt_paid_per_month=>4000///set_scholarship_tt_interest=>184.25///set_scholarship_tt_repayment=>40184.25///set_scholarship_tt_amount_paid=>8000.00///set_scholarship_tt_amount_interest=>32000///set_scholarship_tt_no_inst_paid=>10///set_scholarship_tt_no_inst_remain=>0///set_scholarship_tt_total_interest_in_rev=>184.25///set_scholarship_tt_total_payment_installment_in_rev=>39815.75///set_scholarship_tt_total_paid_per_month_for_cal_in_rev=>40000.00///set_scholarship_tt_op_balance_current=>32,063.36///set_scholarship_tt_op_balance_next=>184.25///set_scholarship_tt_table=>[{\"receipt_no\":\"b1\",\"receipt_date\":\"2025-07-23\",\"amount\":\"4000\"},{\"receipt_no\":\"b2\",\"receipt_date\":\"2025-07-08\",\"amount\":\"4000\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"}]///','2025-07-23 14:56:50','2025-07-23 14:56:50'),(13,4,'INSERT',109,'Dept Inst','debtor_inst_lost_student_id=>102///debtor_inst_lost_student_type=>Loan///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 15:09:41','2025-07-23 15:09:41'),(14,4,'UPDATE',109,'Dept Inst','debtor_inst_lost_time_month2=>2025-04-11///debtor_inst_lost_time_nearly_expired=>2028-04-11///debtor_inst_lost_time_expired=>2030-04-11///debtor_inst_lost_time_sixmonth=>2025-10-11///debtor_inst_lost_status=>Lost_2_month///','2025-07-23 15:11:05','2025-07-23 15:11:05'),(15,4,'INSERT',110,'Dept Inst','debtor_inst_lost_student_id=>103///debtor_inst_lost_student_type=>Scholarship///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 15:11:08','2025-07-23 15:11:08'),(16,4,'UPDATE',110,'Dept Inst','debtor_inst_lost_time_month2=>2025-04-11///debtor_inst_lost_time_nearly_expired=>2027-04-11///debtor_inst_lost_time_expired=>2030-04-11///debtor_inst_lost_time_sixmonth=>2025-10-11///debtor_inst_lost_status=>Lost_2_month///','2025-07-23 15:11:19','2025-07-23 15:11:19'),(17,4,'INSERT',111,'Dept Inst','debtor_inst_lost_student_id=>102///debtor_inst_lost_student_type=>Loan///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 16:16:32','2025-07-23 16:16:32'),(18,4,'UPDATE',111,'Dept Inst','debtor_inst_lost_time_month2=>2025-04-11///debtor_inst_lost_time_nearly_expired=>2028-04-11///debtor_inst_lost_time_expired=>2030-04-11///debtor_inst_lost_time_sixmonth=>2025-10-11///debtor_inst_lost_status=>Lost_2_month///','2025-07-23 16:17:28','2025-07-23 16:17:28'),(19,4,'INSERT',112,'Dept Inst','debtor_inst_lost_student_id=>103///debtor_inst_lost_student_type=>Scholarship///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 16:18:51','2025-07-23 16:18:51'),(20,4,'INSERT',113,'Dept Inst','debtor_inst_lost_student_id=>102///debtor_inst_lost_student_type=>Loan///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 16:25:50','2025-07-23 16:25:50'),(21,4,'INSERT',114,'Dept Inst','debtor_inst_lost_student_id=>102///debtor_inst_lost_student_type=>Loan///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 16:29:50','2025-07-23 16:29:50'),(22,4,'UPDATE',114,'Dept Inst','debtor_inst_lost_time_month2=>2025-04-11///debtor_inst_lost_time_nearly_expired=>2028-04-11///debtor_inst_lost_time_expired=>2030-04-11///debtor_inst_lost_time_sixmonth=>2025-10-11///debtor_inst_lost_status=>Lost_2_month///','2025-07-23 16:29:50','2025-07-23 16:29:50'),(23,4,'INSERT',115,'Dept Inst','debtor_inst_lost_student_id=>103///debtor_inst_lost_student_type=>Scholarship///debtor_inst_lost_no_year=>5///debtor_inst_lost_time_month1=>2025-03-11///debtor_inst_lost_mail_time_month1=>2025-03-14///debtor_inst_lost_status=>Lost_1_month///debtor_inst_lost_mail_month1=>send///','2025-07-23 16:29:50','2025-07-23 16:29:50'),(24,4,'INSERT',15,'Dept Inst Date Notice','date_notice_inst_student=>103///date_notice_inst_date_for_notice_1=>2025-05-01///date_notice_inst_after_30_date=>2025-05-31///date_notice_inst_date_for_notice_2=>2025-06-01///date_notice_inst_date_for_notice_2_180=>2025-11-28///date_notice_inst_status=>Waiting///date_notice_inst_status_mail=>pending///','2025-07-23 16:34:44','2025-07-23 16:34:44'),(25,4,'INSERT',16,'Dept Inst Date Notice','date_notice_inst_student=>102///date_notice_inst_date_for_notice_1=>2025-05-01///date_notice_inst_after_30_date=>2025-05-31///date_notice_inst_date_for_notice_2=>2025-06-01///date_notice_inst_date_for_notice_2_180=>2025-11-28///date_notice_inst_status=>Waiting///date_notice_inst_status_mail=>pending///','2025-07-23 16:35:19','2025-07-23 16:35:19'),(26,4,'UPDATE',16,'Date Notice Inst Fonk Mai Koom','date_notice_inst_status=>fonk_mai_koom///date_notice_inst_day_record=>2025-07-09///date_notice_inst_reason=>xxxxxx///date_notice_inst_status_mail=>notice_1///date_notice_inst_status_mail_number=>1///','2025-07-23 16:44:33','2025-07-23 16:44:33'),(27,4,'UPDATE',15,'Date Notice Inst Fonk Koom','date_notice_inst_status=>fonk_koom///date_notice_inst_day_record=>2025-07-24///date_notice_inst_reason=>yyyy///date_notice_inst_status_mail=>No Mail///','2025-07-23 16:44:48','2025-07-23 16:44:48'),(28,4,'INSERT',104,'Student List','student_code=>6130203639///student_name=>test_sch _lost///student_firstname=>test_sch///student_lastname=>_lost///student_curriculum=>1///student_type=>1///student_school=>1///student_nationality=>2///student_advisor=>2///student_degree=>Bachelor///student_email=>arnuparp.saej1@hotmail.com///student_academicstatus=>7///student_end_date_student_status_siit=>2025-07-01///student_end_date_student_status=>2025-03-01///student_start_year=>24///student_end_year=>26///student_semester_from=>2///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>///student_agreement_date=>///student_guarantor_firstname=>Jugjug///student_guarantor_lastname=>Jigjig4///student_guarantor_email=>guarantor1@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>13000///student_outstanding_balance_payment=>2025-04-30///student_remark=>cxxx///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>lost_call///','2025-07-24 10:18:55','2025-07-24 10:18:55'),(29,4,'INSERT',105,'Student List','student_code=>6130203639///student_name=>test_sch _inst///student_firstname=>test_sch///student_lastname=>_inst///student_curriculum=>1///student_type=>1///student_school=>2///student_nationality=>2///student_advisor=>2///student_degree=>Bachelor///student_email=>asdasd@hotmail.com///student_academicstatus=>1///student_end_date_student_status_siit=>///student_end_date_student_status=>///student_start_year=>21///student_end_year=>24///student_semester_from=>1///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>Doggy-200///student_agreement_date=>2025-07-14///student_guarantor_firstname=>///student_guarantor_lastname=>///student_guarantor_email=>///student_debt_status=>Active///student_outstanding_balance=>25000///student_outstanding_balance_payment=>///student_remark=>yyyy///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>///','2025-07-24 10:22:35','2025-07-24 10:22:35'),(30,4,'INSERT',64,'Set Loan','set_loan_tt_student=>105///set_loan_tt_rivision=>1///set_loan_tt_op_balance=>25000///set_loan_tt_no_status=>Active///set_loan_tt_no_inst_approved=>25///set_loan_tt_payment_date=>2025-01///set_loan_tt_interest_rate=>1///','2025-07-24 10:23:05','2025-07-24 10:23:05'),(31,4,'UPDATE',64,'Set Loan','set_loan_tt_paid_per_month=>1000///set_loan_tt_interest=>274.47///set_loan_tt_repayment=>25274.47///set_loan_tt_amount_paid=>1000.00///set_loan_tt_amount_interest=>24000///set_loan_tt_no_inst_paid=>25///set_loan_tt_no_inst_remain=>0///set_loan_tt_total_interest_in_rev=>274.47///set_loan_tt_total_payment_installment_in_rev=>24725.53///set_loan_tt_total_paid_per_month_for_cal_in_rev=>25000.00///set_loan_tt_op_balance_current=>24,020.83///set_loan_tt_op_balance_next=>274.47///set_loan_tt_table=>[{\"receipt_no\":\"a1\",\"receipt_date\":\"2025-07-01\",\"amount\":\"1000\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"}]///','2025-07-24 10:23:36','2025-07-24 10:23:36'),(32,4,'UPDATE',104,'Student List','student_code=>6130203639///student_name=>test_sch _lost///student_firstname=>test_sch///student_lastname=>_lost///student_curriculum=>1///student_type=>1///student_school=>1///student_nationality=>2///student_advisor=>2///student_degree=>Bachelor///student_email=>arnuparp.saej1@hotmail.com///student_academicstatus=>7///student_end_date_student_status_siit=>2025-07-01///student_end_date_student_status=>2025-03-01///student_start_year=>24///student_end_year=>26///student_semester_from=>2///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>///student_agreement_date=>///student_guarantor_firstname=>Jugjug///student_guarantor_lastname=>Jigjig4///student_guarantor_email=>guarantor1@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>13000///student_outstanding_balance_payment=>2025-04-30///student_remark=>cxxx///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>lost_call///','2025-07-24 10:32:39','2025-07-24 10:32:39'),(33,4,'UPDATE',104,'Student List','student_code=>6130203639///student_name=>test_sch _lost///student_firstname=>test_sch///student_lastname=>_lost///student_curriculum=>1///student_type=>1///student_school=>1///student_nationality=>2///student_advisor=>2///student_degree=>Bachelor///student_email=>arnuparp.saej1@hotmail.com///student_academicstatus=>7///student_end_date_student_status_siit=>2025-07-01///student_end_date_student_status=>2025-03-01///student_start_year=>24///student_end_year=>26///student_semester_from=>2///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>///student_agreement_date=>///student_guarantor_firstname=>Jugjug///student_guarantor_lastname=>Jigjig4///student_guarantor_email=>guarantor1@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>13000///student_outstanding_balance_payment=>2025-04-30///student_remark=>cxxx///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>lost_call///','2025-07-24 10:33:43','2025-07-24 10:33:43'),(34,4,'UPDATE',104,'Student List','student_code=>6130203639///student_name=>test_sch _lost///student_firstname=>test_sch///student_lastname=>_lost///student_curriculum=>1///student_type=>1///student_school=>1///student_nationality=>2///student_advisor=>2///student_degree=>Bachelor///student_email=>arnuparp.saej1@hotmail.com///student_academicstatus=>7///student_end_date_student_status_siit=>2025-07-01///student_end_date_student_status=>2025-03-01///student_start_year=>24///student_end_year=>26///student_semester_from=>2///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>///student_agreement_date=>///student_guarantor_firstname=>Jugjug///student_guarantor_lastname=>Jigjig4///student_guarantor_email=>guarantor1@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>13000///student_outstanding_balance_payment=>2025-04-30///student_remark=>cxxx///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>lost_call///','2025-07-24 10:35:27','2025-07-24 10:35:27'),(35,4,'INSERT',28,'Debtor Lost','debtor_payment_lost_student_id=>104///student_debtor_payment_lost_student_typename=>lost_call///debtor_payment_lost_no_year=>10///debtor_payment_lost_time_start=>2025-03-01///debtor_payment_lost_status=>Waiting Contract///','2025-07-24 10:35:27','2025-07-24 10:35:27'),(36,4,'UPDATE',104,'Student List','student_code=>6130203639///student_name=>test_sch _lost///student_firstname=>test_sch///student_lastname=>_lost///student_curriculum=>1///student_type=>1///student_school=>1///student_nationality=>2///student_advisor=>2///student_degree=>Bachelor///student_email=>arnuparp.saej1@hotmail.com///student_academicstatus=>7///student_end_date_student_status_siit=>2025-07-01///student_end_date_student_status=>2025-03-01///student_start_year=>24///student_end_year=>26///student_semester_from=>2///student_semester_to=>1///student_scholarship_program=>///student_scholarship_status=>///student_agreement_no=>///student_agreement_date=>///student_guarantor_firstname=>Jugjug///student_guarantor_lastname=>Jigjig4///student_guarantor_email=>guarantor1@hotmail.com///student_debt_status=>Active///student_outstanding_balance=>13000///student_outstanding_balance_payment=>2025-04-30///student_remark=>cxxx///student_debt_check_one_time=>one_time///student_debt_check_installments=>installments///student_contract_status=>lost_call///','2025-07-24 10:35:37','2025-07-24 10:35:37'),(37,4,'UPDATE',63,'Set Loan','set_loan_tt_paid_per_month=>4500///set_loan_tt_interest=>207.28///set_loan_tt_repayment=>45207.28///set_loan_tt_amount_paid=>13500.00///set_loan_tt_amount_interest=>31500///set_loan_tt_no_inst_paid=>10///set_loan_tt_no_inst_remain=>0///set_loan_tt_total_interest_in_rev=>207.28///set_loan_tt_total_payment_installment_in_rev=>44792.72///set_loan_tt_total_paid_per_month_for_cal_in_rev=>45000.00///set_loan_tt_op_balance_current=>31,601.34///set_loan_tt_op_balance_next=>207.28///set_loan_tt_table=>[{\"receipt_no\":\"a1\",\"receipt_date\":\"2025-07-01\",\"amount\":\"4500\"},{\"receipt_no\":\"a2\",\"receipt_date\":\"2025-07-16\",\"amount\":\"4500\"},{\"receipt_no\":\"a3\",\"receipt_date\":\"2025-07-30\",\"amount\":\"4500\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"},{\"receipt_no\":\"null\",\"receipt_date\":\"null\",\"amount\":\"0.00\"}]///','2025-07-25 14:12:15','2025-07-25 14:12:15');
/*!40000 ALTER TABLE `log_activity` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-12-02 10:00:10
