-
Notifications
You must be signed in to change notification settings - Fork 0
/
MigTickets.php
92 lines (81 loc) · 5.02 KB
/
MigTickets.php
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
<?php
//Starting migrating tickets ... users mails profiles locations itil_categories already migrated
$sql="SELECT id, entities_id, name, date, closedate, solvedate, date_mod, users_id_lastupdater, status, users_id_recipient, content,
urgency, impact, priority, itilcategories_id, type, global_validation, time_to_resolve, time_to_own, begin_waiting_date,
waiting_duration, close_delay_stat, solve_delay_stat, takeintoaccount_delay_stat, actiontime, is_deleted, locations_id,
validation_percent, date_creation FROM glpi_tickets;";
$stmt = $conn_old->prepare($sql);
$stmt->execute();
$tickets = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo 'Migrating tickets...'. PHP_EOL;
try{
$conn_new->beginTransaction();
foreach ($tickets as &$tick) {
$sql = "INSERT INTO glpi_tickets
(entities_id, name, date, closedate, solvedate, date_mod, users_id_lastupdater, status, users_id_recipient, content,
urgency, impact, priority, itilcategories_id, type, global_validation, time_to_resolve, time_to_own, begin_waiting_date,
waiting_duration, close_delay_stat, solve_delay_stat, takeintoaccount_delay_stat, actiontime, is_deleted, locations_id,
validation_percent, date_creation) VALUES
(:entities_id, :name, :date, :closedate, :solvedate, :date_mod, :users_id_lastupdater, :status, :users_id_recipient, :content,
:urgency, :impact, :priority, :itilcategories_id, :type, :global_validation, :time_to_resolve, :time_to_own, :begin_waiting_date,
:waiting_duration, :close_delay_stat, :solve_delay_stat, :takeintoaccount_delay_stat, :actiontime, :is_deleted, :locations_id,
:validation_percent, :date_creation)";
$stmt2 = $conn_new->prepare($sql);
$stmt2->bindParam(':entities_id', $ENTITY_NEW_ID, PDO::PARAM_INT);
$stmt2->bindParam(':name', $tick['name'],PDO::PARAM_STR);
$stmt2->bindParam(':date', $tick['date'],PDO::PARAM_STR);
$stmt2->bindParam(':closedate', $tick['closedate'],PDO::PARAM_STR);
$stmt2->bindParam(':solvedate', $tick['solvedate'],PDO::PARAM_STR);
$stmt2->bindParam(':date_mod', $tick['date_mod'],PDO::PARAM_STR);
if($tick['users_id_lastupdater'] <= 0 || $tick['users_id_lastupdater'] = ''){
$zero=0;
$stmt2->bindParam(':users_id_lastupdater', $zero, PDO::PARAM_INT);
}
else{
$users_id_lastupdater = getNewUserID($tick['users_id_lastupdater']);
$stmt2->bindParam(':users_id_lastupdater', $users_id_lastupdater, PDO::PARAM_INT);
}
$stmt2->bindParam(':status', $tick['status'],PDO::PARAM_INT);
if($tick['users_id_recipient'] <= 0 || $tick['users_id_recipient'] = ''){
$zero=0;
$stmt2->bindParam(':users_id_recipient', $zero, PDO::PARAM_INT);
}else{
$users_id_recipient = getNewUserID($tick['users_id_recipient']);
$stmt2->bindParam(':users_id_recipient', $users_id_recipient, PDO::PARAM_INT);
}
$stmt2->bindParam(':content', $tick['content'],PDO::PARAM_STR);
$stmt2->bindParam(':urgency', $tick['urgency'],PDO::PARAM_INT);
$stmt2->bindParam(':impact', $tick['impact'],PDO::PARAM_INT);
$stmt2->bindParam(':priority', $tick['priority'],PDO::PARAM_INT);
$itilcategories_id = findNewID($itil_categories,$tick['itilcategories_id']);
$stmt2->bindParam(':itilcategories_id', $itilcategories_id, PDO::PARAM_INT);
$stmt2->bindParam(':type', $tick['type'],PDO::PARAM_INT);
$stmt2->bindParam(':global_validation', $tick['global_validation'],PDO::PARAM_INT);
$stmt2->bindParam(':time_to_resolve', $tick['time_to_resolve'],PDO::PARAM_STR);
$stmt2->bindParam(':time_to_own', $tick['time_to_own'],PDO::PARAM_STR);
$stmt2->bindParam(':begin_waiting_date', $tick['begin_waiting_date'],PDO::PARAM_STR);
$stmt2->bindParam(':waiting_duration', $tick['waiting_duration'],PDO::PARAM_STR);
$stmt2->bindParam(':close_delay_stat', $tick['close_delay_stat'],PDO::PARAM_STR);
$stmt2->bindParam(':solve_delay_stat', $tick['solve_delay_stat'],PDO::PARAM_STR);
$stmt2->bindParam(':takeintoaccount_delay_stat', $tick['takeintoaccount_delay_stat'],PDO::PARAM_STR);
$stmt2->bindParam(':actiontime', $tick['actiontime'],PDO::PARAM_STR);
$stmt2->bindParam(':is_deleted', $tick['is_deleted'],PDO::PARAM_INT);
$locations_id = findNewID($locations,$tick['locations_id']);
$stmt2->bindParam(':locations_id', $locations_id, PDO::PARAM_STR);
$stmt2->bindParam(':validation_percent', $tick['validation_percent'],PDO::PARAM_STR);
$stmt2->bindParam(':date_creation', $tick['date_creation'],PDO::PARAM_STR);
$stmt2->execute();
$tick['new_id'] = $conn_new->lastInsertId();
echo "Inserting ticket nº : ".$tick['new_id'].PHP_EOL;
}
$conn_new->commit();
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage() . PHP_EOL;
$conn_new->rollBack();
}
include 'MigTicketsTickets.php';
include 'MigTicketsUsers.php';
include 'MigTicketsItilFollowups.php';
include 'MigTicketsItilSolutions.php';
?>