public function getPostulantesEvaluacionByVacante($vacante)
{
$sql = "select u.id as usuario_id, v.id as vacante_id , et.id as etapa_id, u.nombres, u.apellidos, u.numero_identificacion, v.titulo, et.nombre as etapa, e.valor, e.observacion\n\t\t\t\tfrom vacante as v \n\t\t\t\tinner join postulacion as p on p.vacante_id = v.id\n\t\t\t\tinner join usuario as u on p.postulante_id = u.id \n\t\t\t\tinner join evaluacion as e on e.postulacion_id = p.id\n\t\t\t\tinner join etapa as et on et.id = e.etapa_id\n\t\t\twhere v.id = {$vacante} or 999 = {$vacante}\n\t\torder by u.id, v.id, et.id";
$model = new model();
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function deleteCategoria()
{
$categoria = $_GET['id'];
$sql = "delete from categoria where id = " . $categoria;
$model = new model();
$result = $model->runSql($sql);
}
function validaLogin()
{
$email = $_POST['email'];
$senha = $_POST['senha'];
echo '1';
if (!isset($email) || !isset($senha)) {
sessao_limpa();
}
echo '2';
if (strlen(trim($email)) == 0 || strlen(trim($senha) == 0)) {
header("Location: /login/error/msg/u_s");
}
echo '3';
$model = new model();
$query = "SELECT * FROM usuario WHERE email_usuario = '{$email}' AND senha_usuario = '{$senha}'";
$result = $model->readSQL($query);
$session = new session();
if ($result) {
$session->sessao_grava($result[0]['email_usuario'], $result[0]['id_usuario_tipo']);
header("Location: /index");
} else {
$session->sessao_limpa();
header("Location: /login/error/msg/u_s");
}
}
function action_comments_list()
{
global $data;
$comm = new model("comments");
$data["articles"] = $comm->page("service_id,object_id,id,ip,create_time,author,service_name");
v();
}
public function mostraGrid()
{
$total_reg = "10";
// número de registros por página
$pagina = $_SESSION['pagina'];
if (!$pagina) {
$pc = "1";
} else {
$pc = $pagina;
}
$inicio = $pc - 1;
$inicio = $inicio * $total_reg;
//list all records
$estado_model = new estadoModel();
$model = new model();
$qry_limitada = $estado_model->getEstado('stat<>0', $inicio . ',' . $total_reg);
//Full table Scan :( or :)
//send the records to template sytem
$this->smarty->assign('listestado', $qry_limitada);
// Total de Registros na tabela
$qry_total = $model->readSQL("SELECT count(*)as total FROM estado WHERE stat<>0");
$total_registros = $qry_total[0]['total'];
//pega o valor
$html = $this->paginador($pc, $total_registros, 'estado');
return $html;
}
/**
* Obtiene Categorias
*/
public function getCategoriaList()
{
$model = new model();
$sql = "select * from categoria ";
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function calculate($address_id)
{
$total = 0;
$model = new model("fare");
$fare = $model->where("is_default=1")->find();
if ($fare) {
$addr = $model->table('address')->where("id={$address_id}")->find();
if ($addr) {
$city = $addr['city'];
$first_price = $fare['first_price'];
$second_price = $fare['second_price'];
$first_weight = $fare['first_weight'];
$second_weight = $fare['second_weight'];
$zoning = unserialize($fare['zoning']);
foreach ($zoning as $zon) {
if (preg_match(',' . $city . ',', ',' . $zon['area'] . ',') > 0) {
$first_price = $zon['f_price'];
$second_price = $zon['s_price'];
$first_weight = $zon['f_weight'];
$second_weight = $zon['s_weight'];
break;
}
}
if ($this->weight <= $first_weight) {
$total = $first_price;
} else {
$weight = $this->weight - $first_weight;
$total = $first_price + ceil($weight / $second_weight) * $second_price;
}
}
}
return sprintf("%01.2f", $total);
}
function index()
{
$dsn = array();
$this->sv("rooturl", preg_replace('/&t=.*/', '', $_SERVER['REQUEST_URI']));
if (f('submit')) {
$dsn['dbHost'] = either(f("host"), "db4free.net");
$dsn['port'] = either(f("port"), 3306);
$dsn['dbHost'] .= ":" . $dsn['port'];
$dsn['dbName'] = either(f("db"), "greedisok");
$dsn['dbUser'] = either(f("user"), "greedisok");
$dsn['dbPswd'] = either(f("pass"), 'greedisok');
$dsn["charset"] = "";
include_once ROOT . "lib/vip/DBUtil.php";
$db = new DB($dsn);
include_once ROOT . "app/main/model.php";
$modelobj = new model($db);
$this->sv("dsn", $dsn);
try {
$this->sv("table_list", $modelobj->table_names());
$table = f('t');
if ($table) {
$modelobj->change_table($table);
$table_detail = $modelobj->detail();
$this->sv("table_detail", $table_detail);
}
} catch (Exception $e) {
$this->sv("info", $e->getMessage());
}
}
}
/**
* 实例化模型类
*/
function M($table)
{
static $modelArray = array();
if (isset($modelArray[$table])) {
return $modelArray[$table];
} else {
if (file_exists(APP_PATH . 'model' . DIRECTORY_SEPARATOR . $table . 'Model.php')) {
$model = $table . 'Model';
$model = new $model();
$modelArray[$table] = $model;
} else {
$model = new model();
//设置表名
$model->table = $table;
//获取属性绑定
$attribute = array();
$colums = $model->findAllBySql("select COLUMN_NAME from information_schema.columns where table_name='{$model->pre}{$model->table}'");
foreach ($colums as $val) {
$attribute[$val['COLUMN_NAME']] = $val['COLUMN_NAME'];
}
$model->attributes = $attribute;
$modelArray[$table] = $model;
}
return $model;
}
}
public function deleteArea()
{
$area = $_GET['id'];
$sql = "update area set eliminado = 1 where id = " . $area;
$model = new model();
$result = $model->runSql($sql);
}
public function getUsuarioByCedula($cedula)
{
$model = new model();
$sql = "select * from usuario where numero_identificacion = " . $cedula;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
return $resultArray[0];
}
public function obtenerUsuario($usuario)
{
$model = new model();
$sql = "Select * from usuario where numero_identificacion = " . $usuario;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
return $resultArray[0];
}
public function run()
{
$m = new AuditTrail();
$m->unsetAttributes();
$m->model = get_class($this->model);
$m->model_id = $this->model->getPrimaryKey();
$this->renderpartial('history', array('model' => $m, 'id' => $this->id));
}
function complement_user_profile($user)
{
include_once "model.php";
include_once "view.php";
$model = new model();
$view = new view();
$result = $model->get_agencies();
$view->profile_fields($user, $result);
}
public function db()
{
jiashu::loadLib('model');
$user = new model('user', 'testdb');
//$r = $user->executeSql('select * from test_user');//you can use executeSql() to query a SQL statment directly.用executeSql()函数可以直接执行SQL语句
$r = $user->field('username,email')->limit('1')->query();
JSFW()->setTplData('r', $r);
JSFW()->render('index');
}
public function getRandomLessonMsg($num)
{
if (isset($num)) {
$xueyuan = new model("xueyuan", "", "");
$xueyuanList = $xueyuan->query("SELECT * FROM zhuanyelesson WHERE l_studentxueyuan IN (SELECT xy_name FROM xueyuan)");
} else {
return false;
}
}
function doAction()
{
//获取任务开始时间
$model = new model('seven_set');
$set = $model->get('*', array('id' => 1));
$start = $set['start'] ? $set['start'] : strtotime(date('Ymd'));
//检测是否有签到记录
$data['openid'] = $_SESSION['openid'];
$data['addtime'] = empty($_POST['date']) ? strtotime(date('Y-m-d')) : $start + 86400 * ($_POST['date'] - 1);
$is_sign = $this->list->has(array('AND' => $data));
//检测是否上传图片
if (empty($_POST["img"])) {
$this->json('请上传图片', 0);
}
$file_path = "static/upload/seven/";
if (!file_exists($file_path) || !is_writable($file_path)) {
@mkdir($file_path, 0755, true);
}
$img = base64_decode(str_replace('data:image/jpeg;base64,', "", $_POST['img']));
$src = $file_path . date('Ymdhis') . rand(1000, 9999) . '.jpg';
file_put_contents($src, $img);
//旋转图片
if (!empty($_POST['deg'])) {
//创建图像资源，以jpeg格式为例
$source = imagecreatefromjpeg($src);
//使用imagerotate()函数按指定的角度旋转
$rotate = imagerotate($source, $_POST['deg'], 0);
//旋转后的图片保存
imagejpeg($rotate, $src);
}
//写入签到记录
if ($is_sign) {
$res = $this->list->update(array('src' => $src), array('AND' => $data));
} else {
$data['src'] = $src;
$res = $this->list->insert($data);
}
if (!$res) {
$this->json('签到失败', 0);
}
//增加连续签到天数
$map['openid'] = $_SESSION['openid'];
$rs = $this->user->get('*', $map);
unset($data['src']);
if (!$rs) {
//没有记录则新增数据
$data['total'] = 1;
$this->user->insert($data);
} else {
//有记录则更新数据
$this->user->update(array('addtime' => $data['addtime'], 'total[+]' => 1), $map);
}
$this->json($is_sign ? '修改成功' : '签到成功', 1);
}
/**
* sync tagger
*
* @param string $key field
* @param model $model eloquent model
*
* @return model
*/
public function eventSyncToTags($key, $model)
{
if (!isset(self::$inputData['tag'])) {
return;
}
if (empty(self::$inputData['tag'])) {
return $model->tags()->detach();
}
$data = explode(',', self::$inputData['tag']);
return $model->tags()->sync($data);
}
/**
*
* @param model $model
*/
public function setUp($model)
{
//echo ' setUp ';
$properties = $model->___get('_properties');
//var_dump($properties);
foreach ($this->_properties as $propertyName => $propertyInfo) {
$properties[$propertyName] = $propertyInfo;
}
$model->___set('_properties', $properties);
$properties = $model->___get('_properties');
//var_dump($properties);
}
public function onRun()
{
$this->page['postPage'] = $this->property('postPage');
$this->page['pageParam'] = $this->paramName('pageNumber');
$this->page['noPostsMessage'] = $this->property('noPostsMessage');
$this->news = $this->page['news'] = NewsModel::published()->viewNews(['page' => $this->property('pageNumber'), 'perPage' => $this->property('postsPerPage')]);
if ($pageNumberParam = $this->paramName('pageNumber')) {
$currentPage = $this->property('pageNumber');
if ($currentPage > ($lastPage = $this->news->lastPage()) && $currentPage > 1) {
return Redirect::to($this->currentPageUrl([$pageNumberParam => $lastPage]));
}
}
}
public function init()
{
$this->view = false;
// Views disabled
$model = new model();
$model->name = "name";
$model->size = 321;
$model->url = "http://example.com";
$model->save();
$model2 = model::findFirst(array("where" => "name = 'name'"));
$model2->name = "New name for old model";
$model->save();
return false;
}
public function executesql()
{
$db = new model();
$sql = $_POST['sql'];
$sql = stripslashes($sql);
$this->assign('sql', $sql);
$l = $db->query($sql);
if ($l !== false) {
$type = 1;
} else {
$type = 0;
}
$this->assign('type', $type);
$this->display("exesql");
}
function indexAction()
{
//数量
$model = new model();
$total['admin'] = $model->table('admin')->count('*');
$count = $model->table('seven_user')->select('*', array('GROUP' => 'openid'));
$total['sign'] = count($count);
$this->assign('total', $total);
//最新签到
$map['LIMIT'] = 5;
$map['ORDER'] = 'addtime desc';
$list = $model->table('seven_user')->select('*', $map);
$this->assign('list', $list);
$this->display();
}
function __construct()
{
$this->db_config = pc_base::load_config('database');
$this->db_setting = 'default';
$this->table_name = 'category_priv';
parent::__construct();
}
public function __construct()
{
$this->db_config = pc_base::load_config('database');
$this->db_setting = 'default';
$this->table_name = 'search';
parent::__construct();
}
public function sql_query($sql)
{
if (!empty($this->db_tablepre)) {
$sql = str_replace('phpcms_', $this->db_tablepre, $sql);
}
return parent::query($sql);
}
/**
* Construct function.
*
* @access public
* @return void
*/
public function __construct()
{
parent::__construct();
$this->now = time();
$this->setSavePath();
$this->setWebPath();
}
/**
* The construct function.
*
* @access public
* @return void
*/
public function __construct()
{
parent::__construct();
$this->setAgent();
$this->setApiRoot();
$this->classFile = $this->app->loadClass('zfile');
}
function __construct()
{
$this->db_config = pc_base::load_config('database');
$this->db_setting = 'default';
$this->table_name = 'dianping_type';
parent::__construct();
}
public function __construct($par = null)
{
if (is_null($par)) {
$this->mysql = db::getInstance();
if (!empty($_POST['test']) && !empty($_POST['check'])) {
$test_id = (int) $_POST['test'];
$sum = 0;
foreach ($_POST['check'] as $ch) {
$r = $this->mysql->executeQuery("SELECT `id_set` FROM `set_to_test` WHERE `id_set`=:set_id AND `id_test`=:test_id", array(array(':test_id', $test_id, 'integer'), array(':set_id', (int) $ch, 'integer')));
$sum += $r['rows'];
}
if ($sum < 1) {
foreach ($_POST['check'] as $ch) {
$this->mysql->executeQuery("INSERT INTO `set_to_test` (`id_test`, `id_set`) VALUES (:test_id, :set_id)", array(array(':test_id', $test_id, 'integer'), array(':set_id', (int) $ch, 'integer')));
}
$this->data['alert'] = array('type' => 'success', 'mess' => array('addtotest'));
} else {
$this->data['alert'] = array('type' => 'warning', 'mess' => array('testanyet'));
}
}
parent::__construct('adm_menu_set');
$r = $this->mysql->executeQuery("SELECT `id_set`, `s_name` FROM `set`");
while ($row = $r['stmt']->fetch(PDO::FETCH_ASSOC)) {
$this->data['set'][] = $row;
}
$r = $this->mysql->executeQuery("SELECT `id_test`, `t_test_name` FROM `test`");
if ($r['rows'] >= 1) {
while ($row = $r['stmt']->fetch(PDO::FETCH_ASSOC)) {
$this->data['test'][] = $row;
}
}
}
}
