public function getDataFromSource()
 {
     $workspaces = TogglWorkspace::getWorkspaces();
     return $workspaces;
 }
 public function getDataFromSource()
 {
     $projects = TogglWorkspace::getWorkspaceProjects($this->workspace_id);
     return $projects;
 }
Exemple #3
0
 */
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']);