_setTbl('tasks');
}
public function getStatuses( $st = null ) {
$statuses = array(
0 => __('New', 'ai-copilot-content-generator'),
1 => __('Prepared', 'ai-copilot-content-generator'),
2 => __('Processing', 'ai-copilot-content-generator'),
3 => __('Generated', 'ai-copilot-content-generator'),
4 => __('Published', 'ai-copilot-content-generator'), /*Generated & Published*/
5 => __('Scheduled', 'ai-copilot-content-generator'), /*wait cycle time*/
6 => __('Stopped', 'ai-copilot-content-generator'),
7 => __('Error', 'ai-copilot-content-generator'),
8 => __('Pause', 'ai-copilot-content-generator'), /*wait user*/
9 => __('Canceled', 'ai-copilot-content-generator'), /*deleted published posts & not need generate*/
);
return is_null($st) ? $statuses : ( isset($statuses[$st]) ? $statuses[$st] : '' );
}
public function canTaskUpdate( $st ) {
return in_array($st, array(1, 3, 5, 7, 8));
}
public function canTaskStop( $st ) {
return 2 == $st;
}
public function canTaskStart( $st ) {
return in_array($st, array(1, 3, 5, 7, 8));
}
public function canTaskPublished( $st ) {
return 3 == $st;
}
public function canTaskCancel( $st ) {
return 2 != $st;
}
public function canTaskSave( $st ) {
return !in_array($st, array(2, 4, 9));
}
public function isTaskRunning( $st ) {
return 2 == $st || 1 == $st;
}
public function isPublished( $st ) {
return 4 == $st;
}
public function isTaskInPause( $st ) {
return 8 == $st;
}
public function getMinCycle() {
$minCycle = WaicDb::get('SELECT min(cycle) FROM `@__tasks` WHERE cycle>0 AND status<7', 'one');
return $minCycle ? (int) $minCycle : 0;
}
public function getScheduledTask() {
$task = WaicDb::get("SELECT id FROM `@__tasks` WHERE cycle>0 AND status=5 AND (start IS NULL OR TIMESTAMPADD(SECOND,cycle,start)<'" . WaicUtils::getTimestampDB() . "') ORDER BY IFNULL(start, 0) LIMIT 1", 'one');
return $task ? (int) $task : 0;
}
public function getTaskActions( $id, $st ) {
$isStarting = $this->getModule()->getModel('workspace')->getRunningTask() == $id ? 1 : 0;
//$isRunning = $isStarting;
return array(
'start' => (int) ( !$isStarting && $this->canTaskStart($st) ),
'stop' => (int) ( $isStarting || $this->canTaskStop($st) ),
'update' => (int) ( !$isStarting && $this->canTaskUpdate($st) ),
'cancel' => (int) ( !$isStarting && $this->canTaskCancel($st) ),
'running' => (int) $isStarting, //$this->isTaskRunning($st),
'publish' => (int) ( !$isStarting && $this->canTaskPublished($st) ),
'save' => (int) ( !$isStarting && $this->canTaskSave($st) ),
'published' => (int) ( !$isStarting && $this->isPublished($st) ),
'starting' => $isStarting,
);
}
public function saveTask( $feature, $id, $params = array() ) {
if ( in_array( (string) $feature, array( 'workflow', 'template' ), true ) ) {
WaicFrame::_()->pushError( esc_html__( 'Legacy Workflow task mutations are quarantined by the Phase 0 security boundary.', 'ai-copilot-content-generator' ) );
return 0;
}
// only for new tasts or after canceled
$id = (int) $id;
$title = sanitize_text_field(WaicUtils::getArrayValue($params, 'task_title'));
if (empty($title)) {
$title = 'Scenario ' . gmdate('Y-m-d-h-i-s');
}
unset($params['task_title']);
$columns = array(
'feature' => $feature,
'author' => get_current_user_id(),
'title' => $title,
'params' => WaicUtils::jsonEncode($params, true),
'status' => 0,
);
$columns = WaicDispatcher::applyFilters('addTaskColumns_' . $feature, $columns, $params, $id);
if (empty($id)) {
$id = $this->insert($columns);
} else {
$ts = WaicUtils::getTimestampDB();
$columns['updated'] = $ts;
$columns['created'] = $ts;
$this->updateById($columns, $id);
}
return $id;
}
public function getTask( $id ) {
$id = (int) $id;
if (empty($id)) {
return array();
}
$task = $this->getById($id);
if ($task) {
$task['params'] = WaicUtils::jsonDecode($task['params']);
}
return $task;
}
public function updateTask( $id, $params = array() ) {
$id = (int) $id;
$feature = $this->getTaskFeature( $id );
$is_revoke = isset( $params['status'] ) && 6 === (int) $params['status'];
if ( in_array( $feature, array( 'workflow', 'template' ), true ) && ! $is_revoke ) {
WaicFrame::_()->pushError( esc_html__( 'Legacy Workflow task mutations are quarantined by the Phase 0 security boundary.', 'ai-copilot-content-generator' ) );
return 0;
}
$params['updated'] = WaicUtils::getTimestampDB();
if ( isset($params['status']) && ( 4 == $params['status'] || 3 == $params['status'] ) ) {
$task = $this->getTask($id);
if ($task && !empty($task['cycle'])) {
$params['status'] = 5;
}
}
$this->updateById($params, $id);
return $id;
}
public function updateTaskTitle( $id, $title ) {
$id = (int) $id;
if ( in_array( $this->getTaskFeature( $id ), array( 'workflow', 'template' ), true ) ) {
WaicFrame::_()->pushError( esc_html__( 'Legacy Workflow task mutations are quarantined by the Phase 0 security boundary.', 'ai-copilot-content-generator' ) );
return false;
}
$title = wp_strip_all_tags(str_replace(array('"', "'"), array('', ''), stripslashes($title)));
$this->updateById(array('title' => $title), $id);
return $title;
}
public function getTaskTitle( $id ) {
$task = $this->getById($id);
return $task ? $task['title'] : '';
}
public function runTask( $id ) {
$task = $this->getTask($id);
if ( ! empty( $task['feature'] ) && in_array( $task['feature'], array( 'workflow', 'template' ), true ) ) {
WaicFrame::_()->pushError( esc_html__( 'Legacy Workflow execution is quarantined by the Phase 0 security boundary.', 'ai-copilot-content-generator' ) );
return false;
}
if (empty($task)) {
WaicFrame::_()->pushError(esc_html__('Generation task not found', 'ai-copilot-content-generator'));
return false;
}
$status = $task['status'];
if ($this->canTaskStart($status)) {
$task['status'] = 2;
$task['message'] = '';
return $this->updateById(array('status' => 2, 'start' => WaicUtils::getTimestampDB(), 'message' => '', 'end' => null), $id) ? $task : false;
}
if ($this->isTaskRunning($status)) {
return $task;
}
WaicFrame::_()->pushError(esc_html(__('The task has a status', 'ai-copilot-content-generator') . ' ' . $this->getStatuses($status) . ' ' . __('and cannot be started', 'ai-copilot-content-generator')));
return false;
}
public function getTaskFeature( $id ) {
$task = $this->getById($id);
return $task ? $task['feature'] : '';
}
public function getPreparedTask() {
return $this->setSelectFields('id')->setWhere(array('status' => 1))->setLimit(1)->getFromTbl(array('return' => 'one'));
}
public function getTaskByParams( $params, $field = false ) {
if ($field) {
$this->setSelectFields($field);
}
$task = $this->setWhere($params)->setLimit(1)->getFromTbl(array('return' => $field ? 'one' : 'row'));
if ($task && !$field && isset($task['params'])) {
$task['params'] = WaicUtils::jsonDecode($task['params']);
}
return $task;
}
public function getCountTasksByParams( $params ) {
return $this->setWhere($params)->getCount();
}
public function stopTasks( $id = null ) {
$data = array(
'updated' => WaicUtils::getTimestampDB(),
'status' => 8,
);
$where = array('status' => 2);
if (!is_null($id)) {
$where['id'] = (int) $id;
}
return $this->update($data, $where);
}
public function cancelTask( $id, $clear = true ) {
$feature = $this->getTaskFeature($id);
$module = WaicFrame::_()->getModule($feature);
if ($module) {
$model = $module->getModel();
if ($model->isDeleteByCancel()) {
$model->clearEtaps($id);
}
}
$data = array(
'updated' => WaicUtils::getTimestampDB(),
'status' => 9,
'step' => 0,
'steps' => 0,
'recalc' => 0,
);
return $this->updateById($data, (int) $id);
}
public function stopTask( $id ) {
$data = array(
'updated' => WaicUtils::getTimestampDB(),
'status' => 8,
);
return $this->updateById($data, (int) $id);
}
public function recalcTask( $id, $update = array() ) {
$id = (int) $id;
$workspace = $this->getModule()->getModel();
$needStop = $workspace->getRunningTask() == $id;
if ($needStop) {
$update['recalc'] = 1;
} else {
$update['status'] = 0;
$update['updated'] = WaicUtils::getTimestampDB();
}
$this->updateById($update, $id);
if ($needStop) {
$workspace->stopGeneration($id);
return true;
} else {
return $workspace->startGeneration($id);
}
}
public function getTasksList( $where = array() ) {
$list = array();
$tasks = $this->setSelectFields('id, title')->setWhere($where)->getFromTbl();
foreach ($tasks as $task) {
$list[$task['id']] = $task['title'];
}
return $list;
}
public function getHistory( $params ) {
$compact = !empty($params['compact']);
$length = WaicUtils::getArrayValue($params, 'length', 10, 1);
$start = WaicUtils::getArrayValue($params, 'start', 0, 1);
//$search = WaicUtils::getArrayValue(WaicUtils::getArrayValue($params, 'search', array(), 2), 'value');
/*if (!empty($search)) {
$model->addWhere(array('additionalCondition' => "title like '%" . $search . "%'"));
}*/
$order = WaicUtils::getArrayValue($params, 'order', array(), 2);
$orderBy = 0;
$sortOrder = 'DESC';
if ($compact) {
$orders = array('id', 'id', 'title', 'tokens', 'status', 'created', 'author');
} else {
$orders = array('id', 'id', 'title', 'feature', 'tokens', 'status', 'created', 'author');
}
if (isset($order[0])) {
$orderBy = WaicUtils::getArrayValue($order[0], 'column', $orderBy, 1);
$sortOrder = WaicUtils::getArrayValue($order[0], 'dir', $sortOrder);
}
$sortOrder = ( is_string( $sortOrder ) && 'DESC' === strtoupper( $sortOrder ) ) ? 'DESC' : 'ASC';
$feature = WaicUtils::getArrayValue($params, 'feature');
if (!empty($feature)) {
$list = WaicFrame::_()->getModule('workspace')->getFeaturesList();
if (isset($list[$feature])) {
$this->setWhere(array('feature' => $feature));
}
}
$exclude = WaicUtils::getArrayValue($params, 'exclude');
if (!empty($exclude)) {
$this->addWhere(array('additionalCondition' => 'feature' . ( is_array($exclude) ? " NOT IN('" . implode("','", $exclude) . "')" : "!='" . $exclude . "'" )));
}
// Get total pages count for current request
$totalCount = $this->getCount(array('clear' => array('selectFields')));
if ($length > 0) {
if ($start >= $totalCount) {
$start = 0;
}
$this->setLimit($start . ', ' . $length);
}
if (!isset($orders[$orderBy])) {
$orderBy = 6;
}
$this->setOrderBy($orders[$orderBy])->setSortOrder($sortOrder);
$data = $this->getFromTbl();
$data = empty($data) ? array() : $this->_prepareHistoryForTbl($data, $compact, empty($params['actions']) ? false : $params['actions']);
return array(
'data' => $data,
'total' => $totalCount,
);
}
public function _prepareHistoryForTbl( $tasks, $compact, $actions = false ) {
$rows = array();
$module = WaicFrame::_()->getModule('workspace');
$features = $module->getFeaturesList();
$statuses = $this->getStatuses();
foreach ($tasks as $task) {
$id = $task['id'];
$feature = $task['feature'];
$user = get_userdata($task['author']);
$url = esc_url($module->getTaskUrl($id, $feature));
$row = array(
'',
$id,
'' . ( empty($task['title']) ? '???' : $task['title'] ) . '',
);
if (!$compact) {
$row[] = ( empty($features[$feature]) ? '???' : $features[$feature] );
}
$row[] = $task['tokens'];
$row[] = $statuses[$task['status']];
$row[] = $task['created'];
$row[] = ( $user ? $user->get('display_name') : $task['author'] );
if (!$compact) {
$row[] = '';
}
if ($actions) {
$row[] = $actions;
}
$rows[] = $row;
}
return $rows;
}
}