/**
* Pull in Client data
*/
function projectImport()
{
$sql = "SELECT tid, name, description, field_client_tid AS clientId\n FROM taxonomy_term_data\n LEFT JOIN field_data_field_client relatedClient ON relatedClient.entity_id = taxonomy_term_data.tid\n WHERE vid =3";
try {
$db = getConnectionMigrate();
$stmt = $db->query($sql);
$projects = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
foreach ($projects as $drupalRecord) {
$seeIfExists = "SELECT p.clientId, p.drupalId, p.notes, p.id, p.name FROM projects as p\n LEFT JOIN client relatedClient on relatedClient.id = p.clientId\n WHERE p.drupalId = :drupalId";
$dbExists = getConnection();
$queryExists = $dbExists->prepare($seeIfExists);
$queryExistTid = $drupalRecord->tid;
$queryExists->bindParam("drupalId", $queryExistTid);
$queryExists->execute();
$rowExists = $queryExists->fetchAll(PDO::FETCH_OBJ);
$dbExists = null;
if (count($rowExists)) {
$compareRows = migrateCompareProject($rowExists[0], $drupalRecord);
} else {
$insert = migrateInsertProject($drupalRecord);
}
}
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
/**
* Pull in Client data
*/
function tasksImport()
{
//1. Find all tasks in drupal
//2. See if it exists
//3. The pull in all the external relations for that task
$sql = "SELECT \n\t\t\t\tnid, \n\t\t\t\ttitle, \n\t\t\t\tuid, \n\t\t\t\tcreated, \n\t\t\t\tbody_value as body, \n\t\t\t\ttaskStatus.field_status_tid as statusId,\n\t\t\t\tstatusName.name as statusName\n FROM node \n LEFT JOIN field_data_body body ON body.entity_id = node.nid \n\t\t\t\tLEFT JOIN field_data_field_status taskStatus ON taskStatus.entity_id = node.nid \n LEFT JOIN taxonomy_term_data statusName on statusName.tid = taskStatus.field_status_tid\n WHERE type LIKE 'task' LIMIT 100";
try {
$db = getConnectionMigrate();
$stmt = $db->query($sql);
$tasks = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
foreach ($tasks as $drupalRecord) {
$seeIfExists = "SELECT t.id, t.drupalId, t.project_id, t.name, t.assigned, t.notify, t.notes, t.created, t.due,\n t.expected_time, t.status, t.meeting, t.actual_time\n FROM tasks t\n WHERE t.drupalId = :drupalId";
$dbExists = getConnection();
$queryExists = $dbExists->prepare($seeIfExists);
$queryExistNid = $drupalRecord->nid;
$queryExists->bindParam("drupalId", $queryExistNid);
$queryExists->execute();
$rowExists = $queryExists->fetchAll(PDO::FETCH_OBJ);
$dbExists = null;
if (count($rowExists)) {
//$compareRows = migrateCompareProject($rowExists[0], $drupalRecord);
} else {
$insert = migrateInsertTask($drupalRecord);
}
}
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
/**
* Pull in Client data
*/
function clientImport()
{
$sql = "SELECT * FROM taxonomy_term_data WHERE vid = 2";
try {
$db = getConnectionMigrate();
$stmt = $db->query($sql);
$clients = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
foreach ($clients as $drupalRecord) {
$seeIfExists = "SELECT * FROM client WHERE drupalId = :drupalId";
$dbExists = getConnection();
$queryExists = $dbExists->prepare($seeIfExists);
$queryExistTid = $drupalRecord->tid;
$queryExists->bindParam("drupalId", $queryExistTid);
$queryExists->execute();
$rowExists = $queryExists->fetchAll(PDO::FETCH_OBJ);
$dbExists = null;
if (count($rowExists)) {
$compareRows = migrateCompareClient($rowExists[0], $drupalRecord);
} else {
$insert = migrateInsertClient($drupalRecord);
}
}
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
/**
* Pull in Client data
*/
function featuresImport()
{
$sql = "SELECT tid, name, description, p.field_related_project_tid as relatedProjectDrupalId, f.related_project\n FROM taxonomy_term_data f\n\t\tLEFT JOIN field_data_field_related_project p ON p.entity_id = f.tid\n\t\tWHERE vid =8";
try {
$db = getConnectionMigrate();
$stmt = $db->query($sql);
$features = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
foreach ($features as $drupalRecord) {
$seeIfExists = "SELECT f.id, f.drupalId, f.name, f.notes FROM features as f\n WHERE f.drupalId = :drupalId";
$dbExists = getConnection();
$queryExists = $dbExists->prepare($seeIfExists);
$queryExistTid = $drupalRecord->tid;
$queryExists->bindParam("drupalId", $queryExistTid);
$queryExists->execute();
$rowExists = $queryExists->fetchAll(PDO::FETCH_OBJ);
$dbExists = null;
if (count($rowExists)) {
echo "Drupal tid of project {$drupalRecord->relatedProjectDrupalId}";
$compareRows = migrateCompareFeatures($rowExists[0], $drupalRecord);
} else {
$insert = migrateInsertFeatures($drupalRecord);
}
}
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
/**
* Pull in Client data
*/
function peopleImport()
{
$sql = "SELECT uid, mail, name, status from users";
try {
$db = getConnectionMigrate();
$stmt = $db->query($sql);
$users = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
foreach ($users as $drupalRecord) {
$seeIfExists = "SELECT p.email, p.id, p.drupalId, p.fname, p.lname FROM people as p\n WHERE p.drupalId = :drupalId";
$dbExists = getConnection();
$queryExists = $dbExists->prepare($seeIfExists);
$queryExistTid = $drupalRecord->uid;
$queryExists->bindParam("drupalId", $queryExistTid);
$queryExists->execute();
$rowExists = $queryExists->fetchAll(PDO::FETCH_OBJ);
$dbExists = null;
if (count($rowExists)) {
$compareRows = migrateComparePeople($rowExists[0], $drupalRecord);
} else {
$insert = migrateInsertPeople($drupalRecord);
}
}
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
