-
Notifications
You must be signed in to change notification settings - Fork 0
/
MigTicketsTickets.php
32 lines (26 loc) · 1.04 KB
/
MigTicketsTickets.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
<?php
$sql="SELECT id, tickets_id_1, tickets_id_2, link FROM glpi_tickets_tickets;";
$stmt = $conn_old->prepare($sql);
$stmt->execute();
$tickets_tickets = $stmt->fetchAll(PDO::FETCH_ASSOC);
try{
$conn_new->beginTransaction();
foreach ($tickets_tickets as $tt) {
$sql = "INSERT INTO glpi_tickets_tickets (tickets_id_1, tickets_id_2, link) VALUES
(:tickets_id_1, :tickets_id_2, :link);";
$stmt2 = $conn_new->prepare($sql);
$tickets_id_1 = findNewID($tickets, $tt['tickets_id_1']);
$stmt2->bindParam(':tickets_id_1', $tickets_id_1, PDO::PARAM_INT);
$tickets_id_2 = findNewID($tickets, $tt['tickets_id_2']);
$stmt2->bindParam(':tickets_id_2', $tickets_id_2, PDO::PARAM_INT);
$stmt2->bindParam(':link', $tt['link'],PDO::PARAM_INT);
$stmt2->execute();
echo "Inserting ticket correlation.. ID ".$tt['id'].PHP_EOL;
}
$conn_new->commit();
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage() . PHP_EOL;
$conn_new->rollBack();
}
?>