1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

<?php

function DeleteActivity() {
    global $dbh;
    if (isset($_POST['activity_id'])) {
        foreach ($_POST['activity_id'] as $k => $a) {
            $dbh->query("UPDATE `activity` SET `lastupby`=1,`lastupdate`=now(),`actived`=1,`deleted`=1 where activity_id =$a and actived = 1 and deleted = 0");
            $dbh->query("Update activity_stu_list set actived = 1, deleted = 0 where activity_id = $a and actived = 1 and deleted = 0");
            $dbh->query("Update activity_teach_list set actived = 1 , deleted = 0 where activity_id = $a and actived = 1 and deleted = 0");
        }
    }
}

function SaveActivity($POST, $event_id) {
    global $dbh;
    DeleteActivity();
    foreach ($_POST['activity_title'] as $k => $a) {
        $sth = $dbh->prepare("INSERT INTO `activity`(`createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`,`event_id`, `title`, `date`, `start_time`, `end_time`, `payment`, `number_attend`) VALUES (1,now(),1,now(),1,0,?,?,?,?,?,?,?)");
        $sth->bindParam(1, $event_id);
        $sth->bindParam(2, $POST['activity_title'][$k]);
        $sth->bindParam(3, $POST['activity_date'][$k]);
        $sth->bindParam(4, $POST['activity_st'][$k]);
        $sth->bindParam(5, $POST['activity_et'][$k]);
        $sth->bindParam(6, $POST['activity_payment'][$k]);
        $sth->bindParam(7, $POST['activity_attend'][$k]);
        $sth->execute();
        $activity_id = $dbh->lastInsertId();
        SaveStudentRecode($POST['activity_student_id'][$k], $activity_id);
        SaveStaffRecode($POST['activity_staff_id'][$k], $activity_id);
    }
}

function SaveStudentRecode($student_list, $activity_id) {
    Subfunction_SaveRecord($student_list, $activity_id, "INSERT INTO `activity_stu_list`(`activity_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`,"
            . " `stu_linking_id`, `invoice_gened`) VALUES (?,1,now(),1,now(),1,0,?,0)");
}

function SaveStaffRecode($staff_list, $activity_id) {
    Subfunction_SaveRecord($staff_list, $activity_id, "INSERT INTO `activity_teach_list`(`activity_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`,"
            . " `staff_id`, `payroll_gened`) VALUES (?,1,now(),1,now(),1,0,?,0)");
}

function Subfunction_SaveRecord($list, $activity_id, $sql) {
    global $dbh;
    foreach ($list as $w) {
        $sth = $dbh->prepare($sql);
        $sth->bindParam(1, $activity_id);
        $sth->bindParam(2, $w);
        $sth->execute();
    }
}

?>