You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ // this doSQL script is called from the addedit.php script // its purpose is to use the CTimesheet class to interoperate with the database (store, edit) /* the following variables can be retreived via POST from timesheet/addedit.php: ** int task_log_id is '0' if a new database object has to be stored or the id of an existing log that should be overwritten or deleted in the db ** str task_log_name the text of the quote that should be stored */ // create a new instance of the einstein class $obj = new CTimesheet(); $msg = ''; // reset the message string // bind the informations (variables) retrieved via post to the einstein object if (!$obj->bind($_POST)) { $AppUI->setMsg($obj->getError(), UI_MSG_ERROR); $AppUI->redirect(); } if ($_POST['progresso']) { $id = $obj->task_log_task; $sql2 = "UPDATE tasks set task_percent_complete = 100 WHERE task_id=" . $id; db_exec($sql2); } if ($obj->task_log_task) { $id = $obj->task_log_task; $sql = "SELECT task_name FROM tasks WHERE task_id=" . $id; $task = db_loadList($sql); foreach ($task as $row) { $task_log_name = $row['task_name']; }