public function getDataFromSource() { $workspaces = TogglWorkspace::getWorkspaces(); return $workspaces; }
public function getDataFromSource() { $projects = TogglWorkspace::getWorkspaceProjects($this->workspace_id); return $projects; }
*/ try { displayStatus("Establishing database connection"); $db = new PDO('mysql:host=' . $DB_HOST . ';dbname=' . $DB_NAME . ';charset=utf8', '' . $DB_USER . '', '' . $DB_PASS . ''); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { displayStatus("Could not establish a connection to the database."); die; } displayStatus("Connected to database."); Toggl::setKey($TOGGL_KEY); /* * Get a list of projects in our workspace */ displayStatus("Getting workspace projects from Toggl"); $projects = TogglWorkspace::getWorkspaceProjects($TOGGL_WORKSPACE); /* * Here's where the fun begins * Go through all of our projects */ foreach ($projects as $Project) { try { //See if we've already added this project... $stmt = $db->prepare("SELECT * FROM " . $TBL_PROJECTS . " WHERE pid=?"); $stmt->execute(array($Project['id'])); //If we haven't added the project, add it! if ($stmt->rowCount() == 0) { try { $stmt = $db->prepare("INSERT INTO " . $TBL_PROJECTS . " (pid,wid,cid,name,actual_hours) VALUES(:pid,:wid,:cid,:projectname,:actual_hours)"); $stmt->execute(array(':pid' => $Project['id'], ':wid' => $Project['wid'], ':cid' => $Project['cid'], ':projectname' => $Project['name'], ':actual_hours' => $Project['actual_hours'])); displayStatus("Created project " . $Project['id'] . " - " . $Project['name'] . " - " . $Project['cid']);