public function verificaLogin()
{
$dao = new dao();
$sql = sprintf($this->sqlVerificaLogin, $this->getUsuario(), $this->getSenha());
$result = $dao->query($sql);
return $result[0]['qtd'];
}
public function addPhoto($photo, $product_id)
{
$dao = new dao();
try {
$dao->edit("product", "photo", $photo, "id", $product_id);
} catch (Exception $e) {
throw new Exception("Failed addging url picture message: " . $e->getMessage());
}
}
/**
*
* @param <String> $rev_id
* @param <String> $sessionId
* @param <Object> $model boModel
* @param <Object> $blobCB=0 (should have been a causal barrier object but
* not used yet)
*/
static function storeModel($rev_id, $sessionId, $model, $blobCB)
{
wfDebugLog('p2p', ' -> store model into revid : ' . $rev_id . ' sessionid : ' . $sessionId . ' model : ' . $model->getText());
try {
$dao = new dao();
$dao->storeModel($rev_id, $sessionId, $model, $blobCB);
} catch (Exception $e) {
die($e->getMessage());
throw new MWException(__METHOD__ . ' db access problems');
}
}
public function addMe($id_event, $id_product, $id_user, $date_ini)
{
$dao = new dao();
$product = array("id_event" => $id_event, "id_product" => $id_product, "id_user" => $id_user, "date_ini" => $date_ini);
try {
$returnObject = $dao->inster($product, "product");
} catch (Exception $e) {
throw new Exception("Failed product addMe: " . $e->getMessage());
}
return $this->addData($returnObject);
}
function demarrer()
{
$dao = new dao();
$tab_installations = $dao->getInstallations($this->recherche);
$html = "";
$vue = new vueInstallation();
foreach ($tab_installations as $installation) {
$html .= $vue->generer1Installation($installation);
}
$vue->afficher($html);
}
public function addMe($nick, $password, $email, $name)
{
$dao = new dao();
$club = array("email" => $email, "name" => $name);
try {
$returnObject = $dao->inster($club, "club");
} catch (Exception $e) {
throw new Exception("Failed club addMe: " . $e->getMessage());
}
return $this->addData($returnObject);
}
/**
* Display the specified resource.
*
* @param $lang
* @param int $code
* @return \Illuminate\Http\Response
*/
public function show($lang, $code)
{
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
$properties['country'] = Input::get('country');
$properties['flow'] = Input::get('flow');
$properties['from_date'] = Input::get('from_date');
$properties['to_date'] = Input::get('to_date');
$properties['lang'] = $lang;
$commodity = $this->dao->getCommodity($code, $properties);
if (empty($commodity)) {
return response('No data found', Response::HTTP_NO_CONTENT);
}
$response = json_encode($commodity, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
return response($response, Response::HTTP_OK);
}
/**
* Edit a build.
*
* @param int $buildID
* @access public
* @return void
*/
public function edit($buildID)
{
if (!empty($_POST)) {
$changes = $this->build->update($buildID);
if (dao::isError()) {
die(js::error(dao::getError()));
}
if ($changes) {
$actionID = $this->loadModel('action')->create('build', $buildID, 'edited');
$this->action->logHistory($actionID, $changes);
}
die(js::locate(inlink('view', "buildID={$buildID}"), 'parent'));
}
$this->loadModel('story');
$this->loadModel('bug');
$this->loadModel('project');
/* Set menu. */
$build = $this->build->getById((int) $buildID);
$this->project->setMenu($this->project->getPairs(), $build->project);
/* Get stories and bugs. */
$orderBy = 'status_asc, stage_asc, id_desc';
$stories = $this->story->getProjectStories($build->project, $orderBy);
$bugs = $this->bug->getProjectBugs($build->project);
/* Assign. */
$this->view->title = $this->lang->build->edit;
$this->view->position[] = $this->lang->build->edit;
$this->view->products = $this->project->getProducts($build->project);
$this->view->build = $build;
$this->view->users = $this->loadModel('user')->getPairs('nodeleted', $build->builder);
$this->view->stories = $stories;
$this->view->bugs = $bugs;
$this->view->orderBy = $orderBy;
$this->display();
}
/**
* Change password , if use default password ,go to change
*
* @access public
* @return void
*/
public function changePassword()
{
if ($this->app->user->account == 'guest') {
die(js::alert('guest') . js::locate('back'));
}
if (!empty($_POST)) {
$password1 = $_POST['password1'];
if (!$password1) {
die(js::error('Please input password!'));
}
$isDefult = $this->dao->select('password')->from(TABLE_DEFAULTPASSWORD)->Where('password')->eq($this->post->password1)->fetchAll();
//如果用户使用默认密码则跳到修改密码界面
if ($isDefult) {
die(js::error('Password can not in default list!') . js::locate($this->createLink('my', 'changePassword', 'type=forbidden'), 'parent'));
}
$this->user->updatePassword($this->app->user->id);
if (dao::isError()) {
die(js::error(dao::getError()));
}
die(js::locate($this->createLink('my', 'profile'), 'parent'));
}
$this->view->title = $this->lang->my->common . $this->lang->colon . $this->lang->my->changePassword;
$this->view->position[] = $this->lang->my->changePassword;
$this->view->user = $this->user->getById($this->app->user->id);
$this->display();
}
/**
* Create resume.
*
* @param int $contactID
* @param object $resume
* @access public
* @return int
*/
public function create($contactID, $resume = null)
{
if (empty($resume)) {
$resume = fixer::input('post')->add('contact', $contactID)->remove('newCustomer,type,size,status,level,name')->get();
if ($this->post->newCustomer) {
$customer = new stdclass();
$customer->name = $this->post->name;
$customer->type = $this->post->type;
$customer->size = $this->post->size;
$customer->status = $this->post->status;
$customer->level = $this->post->level;
$customer->assignedTo = $this->app->user->account;
$customer->createdBy = $this->app->user->account;
$customer->createdDate = helper::now();
$return = $this->loadModel('customer')->create($customer);
if ($return['result'] == 'fail') {
return false;
}
$resume->customer = $return['customerID'];
$this->loadModel('action')->create('customer', $resume->customer, 'Created');
}
}
$this->dao->insert(TABLE_RESUME)->data($resume)->autoCheck()->batchCheck($this->config->resume->require->create, 'notempty')->exec();
if (!dao::isError()) {
$resumeID = $this->dao->lastInsertID();
$this->dao->update(TABLE_CONTACT)->set('resume')->eq($resumeID)->where('id')->eq($contactID)->exec();
return $resumeID;
}
return false;
}
/**
* Create a batch case.
*
* @access public
* @return void
*/
function batchCreate($productID)
{
$now = helper::now();
$cases = fixer::input('post')->get();
for ($i = 0; $i < $this->config->testcase->batchCreate; $i++) {
if ($cases->type[$i] != '' and $cases->title[$i] != '') {
$data[$i]->product = $productID;
$data[$i]->module = $cases->module[$i] == 'same' ? $i == 0 ? 0 : $data[$i - 1]->module : $cases->module[$i];
$data[$i]->type = $cases->type[$i] == 'same' ? $i == 0 ? '' : $data[$i - 1]->type : $cases->type[$i];
$data[$i]->story = $cases->story[$i] == 'same' ? $i == 0 ? 0 : $data[$i - 1]->story : $cases->story[$i];
$data[$i]->title = $cases->title[$i];
$data[$i]->openedBy = $this->app->user->account;
$data[$i]->openedDate = $now;
$data[$i]->status = 'normal';
$data[$i]->version = 1;
if ($data[$i]->story != 0) {
$data[$i]->storyVersion = $this->loadModel('story')->getVersion($this->post->story);
}
$this->dao->insert(TABLE_CASE)->data($data[$i])->autoCheck()->batchCheck($this->config->testcase->create->requiredFields, 'notempty')->exec();
if (dao::isError()) {
echo js::error(dao::getError());
die(js::reload('parent'));
}
$caseID = $this->dao->lastInsertID();
$actionID = $this->loadModel('action')->create('case', $caseID, 'Opened');
} else {
unset($cases->module[$i]);
unset($cases->type[$i]);
unset($cases->story[$i]);
unset($cases->title[$i]);
}
}
}
/**
* Block Admin Page.
*
* @param int $index
* @param string $blockID
* @access public
* @return void
*/
public function admin($index = 0, $blockID = '')
{
$this->app->loadLang('block', 'sys');
$title = $index == 0 ? $this->lang->block->createBlock : $this->lang->block->editBlock;
if (!$index) {
$index = $this->block->getLastKey('team') + 1;
}
if ($_POST) {
$this->block->save($index, 'system', 'team');
if (dao::isError()) {
$this->send(array('result' => 'fail', 'message' => dao::geterror()));
}
$this->send(array('result' => 'success', 'message' => $this->lang->saveSuccess, 'locate' => $this->server->http_referer));
}
$block = $this->block->getBlock($index, 'team');
$blockID = $blockID ? $blockID : ($block ? $block->block : '');
$blocks = json_decode($this->block->getAvailableBlocks(), true);
$this->view->blocks = array_merge(array(''), $blocks);
$this->view->title = $title;
$this->view->params = $blockID ? json_decode($this->block->{'get' . ucfirst($blockID) . 'Params'}(), true) : array();
$this->view->blockID = $blockID;
$this->view->block = $block;
$this->view->index = $index;
$this->display();
}
/**
* update an address.
*
* @param int $id
* @access public
* @return void
*/
public function update($id)
{
$product = new stdclass();
$address = fixer::input('post')->add('account', $this->app->user->account)->get();
$this->dao->update(TABLE_ADDRESS)->data($address)->where('id')->eq($id)->beginIf(RUN_MODE == 'front')->andWhere('account')->eq($this->app->user->account)->fi()->batchCheck($this->config->address->require->edit, 'notempty')->exec();
return !dao::isError();
}
/**
* Install web app.
*
* @param int $webappID
* @access public
* @return void
*/
public function install($webappID)
{
$result = $this->webapp->install($webappID);
if (dao::isError()) {
$this->send(array('result' => 'fail', 'message' => dao::getError(), 'locate' => $this->createLink('webapp', 'obtain')));
}
$this->send(array('result' => 'success', 'message' => $this->lang->webapp->successInstall, 'locate' => $this->createLink('entry', 'admin'), 'entries' => $this->loadModel('entry')->getJSONEntries()));
}
/**
* Delete an address.
*
* @param int $id
* @access public
* @return void
*/
public function delete($id)
{
$this->dao->delete()->from(TABLE_ADDRESS)->where('id')->eq($id)->andWhere('account')->eq($this->app->user->account)->exec();
if (dao::isError()) {
$this->send(array('result' => 'fail', 'message' => dao::getError()));
}
$this->send(array('result' => 'success', 'message' => $this->lang->deleteSuccess, 'locate' => inlink('browse')));
}
/**
* Save search query.
*
* @access public
* @return void
*/
public function saveQuery()
{
$this->search->saveQuery();
if (dao::isError()) {
die(js::error(dao::getError()));
}
die('success');
}
/**
* Update a product.
*
* @param int $productID
* @access public
* @return void
*/
public function update($productID)
{
$oldProduct = $this->getByID($productID);
$product = fixer::input('post')->add('editedBy', $this->app->user->account)->add('editedDate', helper::now())->get();
$this->dao->update(TABLE_PRODUCT)->data($product)->autoCheck()->batchCheck($this->config->product->require->edit, 'notempty')->where('id')->eq($productID)->exec();
if (dao::isError()) {
return false;
}
return commonModel::createChanges($oldProduct, $product);
}
/**
* Update a release.
*
* @param int $releaseID
* @access public
* @return void
*/
public function update($releaseID)
{
$oldRelease = $this->getByID($releaseID);
$release = fixer::input('post')->stripTags('name')->setDefault('stories', '')->setDefault('bugs', '')->join('stories', ',')->join('bugs', ',')->get();
$this->dao->update(TABLE_RELEASE)->data($release)->autoCheck()->batchCheck($this->config->release->edit->requiredFields, 'notempty')->check('name', 'unique', "id != {$releaseID}")->where('id')->eq((int) $releaseID)->exec();
$this->dao->update(TABLE_STORY)->set('stage')->eq('released')->where('id')->in($release->stories)->exec();
if (!dao::isError()) {
return common::createChanges($oldRelease, $release);
}
}
/**
* Create an article.
*
* @access public
* @return void
*/
public function create()
{
if (!empty($_POST)) {
$blogID = $this->blog->create();
if (dao::isError()) {
die(js::error(dao::getError()) . js::locate('back'));
}
die(js::locate(inlink('index')));
}
$this->view->title = $this->lang->blog->add;
$this->display();
}
/**
* Set link for a tag.
*
* @param int $tagID
* @access public
* @return void
*/
public function link($tagID)
{
if ($_POST) {
$this->dao->update(TABLE_TAG)->set('link')->eq($this->post->link)->where('id')->eq($tagID)->exec();
if (!dao::isError()) {
$this->send(array('result' => 'success'));
}
$this->send(array('result' => 'fail', 'message' => dao::getError()));
}
$this->view->tag = $this->dao->select('*')->from(TABLE_TAG)->where('id')->eq($tagID)->fetch();
$this->display();
}
public function setConfig($pubuConfig)
{
try {
$this->loadModel('setting')->setItems('system.pubu', $pubuConfig);
if (dao::isError()) {
return dao::getError();
} else {
}
} catch (Exception $err) {
return $err;
}
return true;
}
/**
* Set link for a tag.
*
* @param int $tagID
* @access public
* @return void
*/
public function link($tagID)
{
if ($_POST) {
$this->dao->update(TABLE_TAG)->set('link')->eq($this->post->link)->where('id')->eq($tagID)->exec();
if (!dao::isError()) {
$this->send(array('result' => 'success', 'message' => $this->lang->saveSuccess));
}
$this->send(array('result' => 'fail', 'message' => dao::getError()));
}
$this->view->title = "<i class='icon-edit'></i> " . $this->lang->tag->editLink;
$this->view->tag = $this->dao->select('*')->from(TABLE_TAG)->where('id')->eq($tagID)->fetch();
$this->display();
}
/**
* Custom
*
* @param string $module
* @param string $field
* @access public
* @return void
*/
public function set($module = 'story', $field = 'priList')
{
if ($module == 'user' and $field == 'priList') {
$field = 'roleList';
}
$currentLang = $this->app->getClientLang();
$this->app->loadLang($module);
$this->app->loadConfig('story');
$fieldList = $this->lang->{$module}->{$field};
if ($module == 'bug' and $field == 'typeList') {
unset($fieldList['designchange']);
unset($fieldList['newfeature']);
unset($fieldList['trackthings']);
}
if (!empty($_POST)) {
if ($module == 'story' && $field == 'review') {
$this->loadModel('setting')->setItem('system.story.needReview', fixer::input('post')->get()->needReview);
} else {
$lang = $_POST['lang'];
$this->custom->deleteItems("lang={$lang}&module={$module}§ion={$field}");
foreach ($_POST['keys'] as $index => $key) {
$value = $_POST['values'][$index];
if (!$value or !$key) {
continue;
}
$system = $_POST['systems'][$index];
/* the length of role is 20, check it when save. */
if ($module == 'user' and $field == 'roleList' and strlen($key) > 20) {
die(js::alert($this->lang->custom->notice->userRole));
}
$this->custom->setItem("{$lang}.{$module}.{$field}.{$key}.{$system}", $value);
}
}
if (dao::isError()) {
die(js::error(dao::getError()));
}
die(js::reload('parent'));
}
$this->view->title = $this->lang->custom->common . $this->lang->colon . $this->lang->{$module}->common;
$this->view->position[] = $this->lang->custom->common;
$this->view->position[] = $this->lang->{$module}->common;
$this->view->needReview = $this->config->story->needReview;
$this->view->fieldList = $fieldList;
$this->view->dbFields = $this->custom->getItems("lang={$currentLang},all&module={$module}§ion={$field}");
$this->view->field = $field;
$this->view->module = $module;
$this->view->currentLang = $currentLang;
$this->view->canAdd = strpos($this->config->custom->canAdd[$module], $field) !== false;
$this->display();
}
/**
* Execute a module's model's method, return the result.
*
* @param string $moduleName
* @param string $methodName
* @param string $params param1=value1,param2=value2, don't use & to join them.
* @access public
* @return string
*/
public function getModel($moduleName, $methodName, $params = '')
{
parse_str(str_replace(',', '&', $params), $params);
$module = $this->loadModel($moduleName);
$result = call_user_func_array(array(&$module, $methodName), $params);
if (dao::isError()) {
die(json_encode(dao::getError()));
}
$output['status'] = $result ? 'success' : 'fail';
$output['data'] = json_encode($result);
$output['md5'] = md5($output['data']);
$this->output = json_encode($output);
die($this->output);
}
/**
* Set link for a tag.
*
* @param int $tagID
* @access public
* @return void
*/
public function link($tagID)
{
if ($_POST) {
$link = fixer::input('post')->stripTags('link', $this->config->allowedTags->admin)->get();
$this->dao->update(TABLE_TAG)->data($link)->autoCheck()->where('id')->eq($tagID)->exec();
if (!dao::isError()) {
$this->send(array('result' => 'success', 'message' => $this->lang->saveSuccess));
}
$this->send(array('result' => 'fail', 'message' => dao::getError()));
}
$this->view->title = "<i class='icon-edit'></i> " . $this->lang->tag->editLink;
$this->view->tag = $this->dao->select('*')->from(TABLE_TAG)->where('id')->eq($tagID)->fetch();
$this->display();
}
/**
* Add a prodcut to cart.
*
* @param int $productID
* @param int $count
* @access public
* @return void
*/
public function add($productID, $count)
{
$hasProduct = $this->dao->select('count(*) as count')->from(TABLE_CART)->where('account')->eq($this->app->user->account)->andWhere('product')->eq($productID)->fetch('count');
if (!$hasProduct) {
$product = new stdclass();
$product->product = $productID;
$product->account = $this->app->user->account;
$product->count = $count;
$this->dao->insert(TABLE_CART)->data($product)->exec();
} else {
$this->dao->update(TABLE_CART)->set("count= count + {$count}")->where('account')->eq($this->app->user->account)->andWhere('product')->eq($productID)->exec();
}
return !dao::isError();
}
/**
* Edit cron.
*
* @param int $cronID
* @access public
* @return void
*/
public function edit($cronID)
{
if ($_POST) {
$this->cron->update($cronID);
if (dao::isError()) {
die(js::error(dao::getError()));
}
die(js::locate(inlink('index'), 'parent'));
}
$this->view->title = $this->lang->cron->edit . $this->lang->cron->common;
$this->view->position[] = html::a(inlink('index'), $this->lang->cron->common);
$this->view->position[] = $this->lang->cron->edit;
$this->view->cron = $this->cron->getById($cronID);
$this->display();
}
/**
* Build All index.
*
* @access public
* @return void
*/
public function buildIndex($type = 'article', $lastID = '')
{
if (helper::isAjaxRequest()) {
$result = $this->search->buildAllIndex($type, $lastID);
if (dao::isError()) {
$this->send(array('result' => 'fail', 'message' => dao::getError()));
}
if (isset($result['finished']) and $result['finished']) {
$this->send(array('result' => 'finished', 'message' => $this->lang->search->buildSuccessfully));
} else {
$this->send(array('result' => 'unfinished', 'message' => sprintf($this->lang->search->buildResult, $result['count']), 'next' => inlink('buildIndex', "type={$result['type']}&lastID={$result['lastID']}")));
}
}
$this->view->title = $this->lang->search->buildIndex;
$this->display();
}
/**
* Create an consulting.
*
* @param string $type
* @access public
* @return int|bool
*/
public function create()
{
$now = helper::now();
$consulting = fixer::input('post')->setDefault('addedDate', $now)->get();
$consult = $this->dao->select('*')->from(TABLE_CONSULTING)->where('realname')->eq($consulting->realname)->andWhere('mobile')->eq($consulting->mobile)->andWhere('email')->eq($consulting->email)->fetch();
if ($consult) {
return array('result' => 'fail', 'message' => '请不要重复提交！<a href="javascript:history.back();">返回</a>');
} else {
$this->dao->insert(TABLE_CONSULTING)->data($consulting)->exec();
$consultingID = $this->dao->lastInsertID();
if (dao::isError()) {
return array('result' => 'fail', 'message' => dao::getError());
}
return array('result' => 'success', 'message' => '提交成功！');
}
}
/**
* Copy a group.
*
* @param int $groupID
* @access public
* @return void
*/
public function copy($groupID)
{
$group = fixer::input('post')->specialChars('name, desc')->remove('options')->get();
$this->dao->insert(TABLE_GROUP)->data($group)->check('name', 'unique')->check('name', 'notempty')->exec();
if ($this->post->options == false) {
return;
}
if (!dao::isError()) {
$newGroupID = $this->dao->lastInsertID();
$options = join(',', $this->post->options);
if (strpos($options, 'copyPriv') !== false) {
$this->copyPriv($groupID, $newGroupID);
}
if (strpos($options, 'copyUser') !== false) {
$this->copyUser($groupID, $newGroupID);
}
}
}
