function getUserListFromDB() { global $db; $q = $db->dq("SELECT * FROM {$db->prefix}users"); while ($r = $q->fetch_assoc($q)) { ?> <tr> <td valign="left" class="username"><?php echo $r['username']; ?> </td> <td valign="left" class="email"><?php echo $r['email']; ?> </td> <td valign="left" class="role"><?php echo _e('um_rolename_' . $r['role']); ?> </td> <td valign="left" class="notification"><?php echo NotificationListener::hasGlobalNotifications($r['id']) ? _e('um_notification_on') : _e('um_notification_off'); ?> </td> <td> <a href="#" class="edituser" rel="<?php echo $r['id']; ?> "><?php _e('action_edit'); ?> </a> <?php if ($r['id'] != $_SESSION['userid']) { ?> | <a href="#" class="deleteuser" rel="<?php echo $r['id']; ?> "><?php _e('action_delete'); ?> </a> <?php } ?> </td> </tr> <?php } }
protected function notifications() { $this->myModel = new OrderModel(); $response = NotificationListener::main(); // Verifica se a transação foi paga if ($response->getStatus()->getValue() == 3) { // Atualiza status no documento $data = new stdclass(); $data->id = $response->getReference(); $data->status = Config::read('order.status')['paid']; $this->myModel->update($data); if ($this->myModel->inboxModel) { $order = $this->myModel->selectForDetail($response->getReference()); // // Mensagem para o vendedor // $data = new stdclass; // $data->title = 'Confirmação de pagamento - Pedido nro. '.$response->getReference(); // $data->text = 'O pedido nro. '.$response->getReference().' foi PAGO, envie o produto pelos Correios e insira o código de rastreio em nosso sistema para atualizar o status. O dinheiro será depositado após a confirmação de recebimento pelo comprador.'; // $data->type = 'order'; // $data->reference = $response->getReference(); // $data->account = $order->vendor; // $this->myModel->inboxModel->insert( $data ); // // Mensagem para o comprador // $data = new stdclass; // $data->title = 'Confirmação de pagamento - Pedido nro. '.$response->getReference(); // $data->text = 'O pedido nro. '.$response->getReference().' foi PAGO e o comprador já esta despachando o produto, aguarde a atualização do chamado com o código de rastreio e após recebimento atualize o status do pedido em nosso sistema.'; // $data->type = 'order'; // $data->reference = $response->getReference(); // $data->account = $order->buyer; // $this->myModel->inboxModel->insert( $data ); } } }
function loadTasks($listId, $compl = 0, $tag = '', $s = '', $sort = 0, $setCompl = 0, $setNotification = null) { $db = DBConnection::instance(); $sqlWhere = $inner = ''; if ($listId == -1) { $userLists = getUserListsSimple(); $sqlWhere .= " AND {$db->prefix}todolist.list_id IN (" . implode(array_keys($userLists), ',') . ") "; } else { $sqlWhere .= " AND {$db->prefix}todolist.list_id=" . $listId; } if ($compl == 0) { $sqlWhere .= ' AND compl=0'; } $tag = trim($tag); if ($tag != '') { $at = explode(',', $tag); $tagIds = array(); $tagExIds = array(); foreach ($at as $i => $atv) { $atv = trim($atv); if ($atv == '' || $atv == '^') { continue; } if (substr($atv, 0, 1) == '^') { $tagExIds[] = getTagId(substr($atv, 1)); } else { $tagIds[] = getTagId($atv); } } if (sizeof($tagIds) > 1) { $inner .= "INNER JOIN (SELECT task_id, COUNT(tag_id) AS c FROM {$db->prefix}tag2task WHERE list_id={$listId} AND tag_id IN (" . implode(',', $tagIds) . ") GROUP BY task_id) AS t2t ON id=t2t.task_id"; $sqlWhere = " AND c=" . sizeof($tagIds); //overwrite sqlWhere! } elseif ($tagIds) { $inner .= "INNER JOIN {$db->prefix}tag2task ON {$db->prefix}todolist.id={$db->prefix}tag2task.task_id"; $sqlWhere .= " AND {$db->prefix}tag2task.tag_id = " . $tagIds[0]; } if ($tagExIds) { $sqlWhere .= " AND id NOT IN (SELECT DISTINCT task_id FROM {$db->prefix}tag2task WHERE list_id={$listId} AND tag_id IN (" . implode(',', $tagExIds) . "))"; //DISTINCT ? } } $s = trim($s); if ($s != '') { $sqlWhere .= " AND (title LIKE " . $db->quoteForLike("%%%s%%", $s) . " OR note LIKE " . $db->quoteForLike("%%%s%%", $s) . ")"; } $sort = $sort; $sqlSort = "ORDER BY compl ASC, "; if ($sort == 1) { $sqlSort .= "prio DESC, ddn ASC, duedate ASC, ow ASC"; } elseif ($sort == 101) { $sqlSort .= "prio ASC, ddn DESC, duedate DESC, ow DESC"; } elseif ($sort == 2) { $sqlSort .= "ddn ASC, duedate ASC, prio DESC, ow ASC"; } elseif ($sort == 102) { $sqlSort .= "ddn DESC, duedate DESC, prio ASC, ow DESC"; } elseif ($sort == 3) { $sqlSort .= "d_created ASC, prio DESC, ow ASC"; } elseif ($sort == 103) { $sqlSort .= "d_created DESC, prio ASC, ow DESC"; } elseif ($sort == 4) { $sqlSort .= "d_edited ASC, prio DESC, ow ASC"; } elseif ($sort == 104) { $sqlSort .= "d_edited DESC, prio ASC, ow DESC"; } else { $sqlSort .= "ow ASC"; } $t = array(); $t['total'] = 0; $t['list'] = array(); $q = $db->dq("SELECT *, duedate IS NULL AS ddn FROM {$db->prefix}todolist {$inner} WHERE 1=1 {$sqlWhere} {$sqlSort}"); while ($r = $q->fetch_assoc($q)) { $t['total']++; $t['list'][] = prepareTaskRow($r); } if ($setCompl && have_write_access($listId)) { $bitwise = $compl == 0 ? 'taskview & ~1' : 'taskview | 1'; $db->dq("UPDATE {$db->prefix}lists SET taskview={$bitwise} WHERE id={$listId}"); } if (($setNotification === '0' || $setNotification === '1') && have_write_access($listId)) { if ($setNotification == 1) { NotificationListener::enableNotification(NotificationListener::LISTENER_TYPE_LIST, $listId); } else { NotificationListener::disableNotification(NotificationListener::LISTENER_TYPE_LIST, $listId); } } return $t; }
} /** * verifyData - Corrige os dados enviados via post * @data string Dados enviados via post */ private static function verifyData($data) { return isset($data) && trim($data) !== "" ? trim($data) : null; } /** * getConfig - Retorna as configurações definidas para as credenciais * @return array Array contendo as credenciais do usuário */ private static function getConfig() { global $db; $config = array(); // Settings $query = $db->query("SELECT value FROM " . DB_PREFIX . "setting s where s.key='pagseguro_mail'"); $config['email'] = $query->row['value']; $query = $db->query("SELECT value FROM " . DB_PREFIX . "setting s where s.key='pagseguro_token'"); $config['token'] = $query->row['value']; return $config; } private static function saveLog($strType = null) { #LogPagSeguro::getHtml(); } } NotificationListener::main();
/** * @static * @param $type * @param array $value * @return array * @throws Exception */ public static function findByListenerTypeAndValue($type, $value = null) { if ($type !== NotificationListener::LISTENER_TYPE_GLOBAL && empty($value)) { throw new Exception('Can not find non-global listener (' . $type . ') without a list or task id (' . $value . ')'); } $return = array(); $db = DBConnection::instance(); if ($type === NotificationListener::LISTENER_TYPE_GLOBAL) { $result = $db->dq("SELECT * FROM {$db->prefix}notification_listeners WHERE type = 'global'"); } else { $result = $db->dq("SELECT * FROM {$db->prefix}notification_listeners WHERE type = ? AND value = ?", array($type, $value)); } while ($row = $result->fetch_assoc()) { $item = new NotificationListener(); $item->setType($row['type']); $item->setUserid($row['user_id']); if ($type !== NotificationListener::LISTENER_TYPE_GLOBAL) { $item->setValue($row['value']); } $return[] = $item; } return $return; }
echo $multiUser ? "true" : "false"; ?> , admin: <?php echo is_admin() ? "true" : "false"; ?> , readOnly: <?php echo is_readonly() ? "true" : "false"; ?> , <?php if (isset($_SESSION['userid'])) { ?> globalNotifications: <?php echo NotificationListener::hasGlobalNotifications($_SESSION['userid']) ? "true" : "false"; ?> , userId: <?php echo !empty($_SESSION['userid']) ? $_SESSION['userid'] : 'null'; ?> , userRole: <?php echo !empty($_SESSION['role']) ? $_SESSION['role'] : 'null'; ?> , <?php } ?> isLogged: <?php echo $needAuth && is_logged() ? "true" : "false";