public function total()
{
$result = Trainer::select(DB::raw('sum(full_time_male) as male,
sum(full_time_female) as female,
sum(full_time_male) + sum(full_time_female) as total'))->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->get();
return $result;
}
/**
* Store the job in the database.
*
* Returns the id of the job.
*
* @param string $job
* @param mixed $data
* @param int $delay
*
* @return int
*/
public function storeJob($job, $data, $delay = 0)
{
$payload = $this->createPayload($job, $data);
$database = Config::get('database');
if ($database['default'] === 'odbc') {
$row = DB::select(DB::raw("SELECT laq_async_queue_seq.NEXTVAL FROM DUAL"));
$id = $row[0]->nextval;
$job = new Job();
$job->id = $id;
$job->status = Job::STATUS_OPEN;
$job->delay = $delay;
$job->payload = $payload;
$job->save();
} else {
if ($database['default'] === 'mysql') {
$payload = $this->createPayload($job, $data);
$job = new Job();
$job->status = Job::STATUS_OPEN;
$job->delay = $delay;
$job->payload = $payload;
$job->save();
$id = $job->id;
}
}
return $id;
}
/**
* 重置密钥
* @param $key
*/
public static function reset($key)
{
$phptime = date("Y-m-d H:i:s.u");
$k = substr(str_shuffle(md5(microtime())), rand(1, 5), 18);
DB::table('passports')->where('key', $key)->update(['secret' => $k, 'updated_at' => $phptime]);
return 1;
}
/**
* Handle permissions change
*
* @param Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function putAll(Request $request)
{
$permissions = Permission::all();
$input = array_keys($request->input('permissions'));
try {
DB::beginTransaction();
$permissions->each(function ($permission) use($input) {
if (in_array($permission->id, $input)) {
$permission->allow = true;
} else {
$permission->allow = false;
}
$permission->save();
});
DB::commit();
flash()->success(trans('permissions.save_success'));
} catch (\Exception $e) {
var_dump($e->getMessage());
die;
flash()->error(trans('permissions.save_error'));
}
try {
Cache::tags(['permissions'])->flush();
} catch (\Exception $e) {
Cache::flush();
}
return redirect()->back();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
if ($this->confirm("Clear database? [Yes|no]", "Yes")) {
$this->info('Clear database start');
if (config('database.default') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=0');
} else {
if (config('database.default') == 'sqlite') {
DB::statement('PRAGMA foreign_keys = OFF');
}
}
$tableNames = Schema::getConnection()->getDoctrineSchemaManager()->listTableNames();
foreach ($tableNames as $v) {
Schema::drop($v);
$this->info('Dropped: ' . $v);
}
$this->info('Clear database end');
if (config('database.default') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=1');
} else {
if (config('database.default') == 'sqlite') {
DB::statement('PRAGMA foreign_keys = ON');
}
}
}
}
public function clear(Request $request)
{
$post = $request->all();
$comment = $post['comment'];
$value = $post['amount'];
$student = $post['regNo'];
$clearedAt = $post['signedAt'];
$clearedBy = $post['signedBy'];
$comment = preg_replace('/[^A-Za-z0-9 _]/', '', $comment);
$value = preg_replace('/[^0-9]/', '', $value);
DB::beginTransaction();
$submit = DB::update("UPDATE charge\n INNER JOIN comments ON charge.students_studentNo = comments.students_studentNo\n INNER JOIN cleared_at ON charge.students_studentNo = cleared_at.students_studentNo\n INNER JOIN cleared_by ON charge.students_studentNo = cleared_by.students_studentNo\n SET\n charge.cafeteria_value = '{$value}',\n charge.queueFlag = charge.queueFlag + 1,\n comments.cafeteria = '{$comment}',\n cleared_at.cafeteria_cleared_at = '{$clearedAt}',\n cleared_by.cafeteria_cleared_by = '{$clearedBy}'\n\n WHERE charge.students_studentNo = '{$student}'\n AND comments.students_studentNo = '{$student}'\n AND cleared_at.students_studentNo = '{$student}'\n AND cleared_by.students_studentNo='{$student}' ");
if ($submit) {
DB::commit();
} else {
DB::rollBack();
}
// $admin = DB::table('departments')
// ->join('administrators','departments.administrator','=','administrators.admin_id')
// ->select('administrators.email')->where('departments.department_name','=','Library')
// ->pluck('email');
//Send Mail
// Mail::send('mails.clear', ['student' => $student ], function($message) use($admin){
// $message->to($admin)->from('*****@*****.**', 'Strathmore University')->subject('Clearance');
// });
return redirect('/cafeteria');
}
public function getMmPoint(Request $request)
{
$key = request('key');
$mmpointM = DB::connection(DBUtils::getDBName())->table('mmpoint_table')->where('A', $key)->first();
// Log::info("lenth ".sizeof($mmtrendM));
return response()->json(['mmpointM' => json_encode($mmpointM)]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('roles')->truncate();
//insert some dummy records
Role::create(['name' => 'Admin', 'status' => 'active']);
/*Role::create([
'name' => 'Project Manager',
'status' => 'active',
]);
Role::create([
'name' => 'Team Lead',
'status' => 'active',
]);
Role::create([
'name' => 'Developer',
'status' => 'active',
]);
Role::create([
'name' => 'Designer',
'status' => 'active',
]);
Role::create([
'name' => 'Tester',
'status' => 'active',
]);*/
DB::table('roles_users')->insert(['user_id' => 1, 'role_id' => 1, 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$count = 0;
$pdo = DB::connection()->getPdo();
$query = "SELECT * FROM archivos_sat;";
$stmt = $pdo->prepare($query);
$stmt->execute();
while ($row = $stmt->fetchObject()) {
$count++;
if ($count % 100 == 0) {
$this->comment("arch sat: " . $count);
}
$archivo = ArchivoSat::find($row->id);
$parser = new ParserCFID($archivo->file);
$parser->parser();
$archivo->fecha = $parser->getFecha();
$archivo->save();
}
$count = 0;
$pdo = DB::connection()->getPdo();
$query = "SELECT * FROM archivos_empresa;";
$stmt = $pdo->prepare($query);
$stmt->execute();
while ($row = $stmt->fetchObject()) {
$count++;
if ($count % 100 == 0) {
$this->comment("arch emp: " . $count);
}
$archivo = ArchivoEmpresa::find($row->id);
$parser = new ParserCFID($archivo->file);
$parser->parser();
$archivo->fecha = $parser->getFecha();
$archivo->save();
}
}
/**
* @test
**/
public function canStartForeignKeysCheckIfSupported()
{
$mock_exec = m::mock('StdClass')->shouldReceive('exec')->once()->with('SET FOREIGN_KEY_CHECKS=1;')->getMock();
$mock_getPdo = m::mock('StdClass')->shouldReceive('getPdo')->once()->andReturn($mock_exec)->getMock();
DB::shouldReceive('connection')->once()->andReturn($mock_getPdo);
DbHelperStub::startForeignKeysCheck();
}
public function unlink(Module $module, Request $request, FileRepository $fileRepository, Imagy $imagy)
{
DB::table('media__imageables')->whereFileId($request->get('fileId'))->delete();
$file = $fileRepository->find($request->get('fileId'));
$imagy->deleteAllFor($file);
$fileRepository->destroy($file);
}
/**
* Remove unused avatar files from disk.
*
* @return void
*/
private function purgeOldAvatars()
{
// Build up a list of all avatar images
$avatars = glob(public_path() . '/upload/*/*.*');
// Remove the public_path() from the path so that they match values in the DB
array_walk($avatars, function (&$avatar) {
$avatar = str_replace(public_path(), '', $avatar);
});
$all_avatars = collect($avatars);
// Get all avatars currently assigned
$current_avatars = DB::table('users')->whereNotNull('avatar')->lists('avatar');
// Compare the 2 collections get a list of avatars which are no longer assigned
$orphan_avatars = $all_avatars->diff($current_avatars);
$this->info('Found ' . $orphan_avatars->count() . ' orphaned avatars');
// Now loop through the avatars and delete them from storage
foreach ($orphan_avatars as $avatar) {
$avatarPath = public_path() . $avatar;
// Don't delete recently created files as they could be temp files from the uploader
if (filemtime($avatarPath) > strtotime('-15 minutes')) {
$this->info('Skipping ' . $avatar);
continue;
}
if (!unlink($avatarPath)) {
$this->error('Failed to delete ' . $avatar);
} else {
$this->info('Deleted ' . $avatar);
}
}
}
/**
* Run the migrations.
*/
public function up()
{
Schema::table('deployments', function (Blueprint $table) {
$table->boolean('is_webhook')->default(false);
});
DB::table('deployments')->whereRaw('user_id IS NULL')->update(['is_webhook' => true]);
}
public function run()
{
DB::table('partners')->delete();
Partner::create(['applicant_id' => 1, 'partner' => 'Pepper Potts', 'title' => 'CFO', 'location' => 'Monroe, LA', 'email' => '*****@*****.**', 'phone' => '5125551020']);
Partner::create(['applicant_id' => 1, 'partner' => 'James Rhodes', 'title' => 'Colonel', 'location' => 'Norfolk, VA', 'email' => '*****@*****.**', 'phone' => '5125559999']);
Partner::create(['applicant_id' => 4, 'partner' => 'Sam Wilson', 'title' => 'Falcon', 'location' => 'Washington, D.C.', 'email' => '*****@*****.**', 'phone' => '5125995599']);
}
public function run()
{
for ($i = 0; $i < 100; $i++) {
DB::table('posts_has_tags')->insert(['post_id' => $i + 1, 'tag_id' => rand(1, 2)]);
DB::table('posts_has_tags')->insert(['post_id' => $i + 1, 'tag_id' => rand(3, 4)]);
}
}
public function postLogin(LoginRequest $request)
{
if (!Auth::attempt(['email' => $request->get('email'), 'password' => $request->get('password')], true)) {
session()->flash('errorMessages', ['You have entered an invalid email address or password.', 'Please try again.']);
return back()->withInput();
}
$user = Auth::user();
// if the user has a plant, set welcome message
if (count($user->plants)) {
$plant = $user->plants()->where('isHarvested', '=', false)->orderBy(DB::raw('RAND()'))->first();
if ($plant) {
// set welcome message to need water or need fertilizer if the plant needs it
$lastTimeWatered = $plant->getLastTimeWatered();
$lastTimeFertilized = $plant->getLastTimeFertilized();
$random = round(rand(1, 2));
if (!$lastTimeWatered && $plant->created_at->addDay() < Carbon::now()) {
$status = $plant->plantCharacter['need_water_phrase_' . $random];
} elseif (!$lastTimeFertilized && $plant->created_at->addDay() < Carbon::now()) {
$status = $plant->plantCharacter['need_fertilizer_phrase_' . $random];
} elseif ($lastTimeWatered && Carbon::createFromFormat('Y-m-d H:i:s', $lastTimeWatered->pivot->date)->addDay() < Carbon::now()) {
$status = $plant->plantCharacter['need_water_phrase_' . $random];
} elseif ($lastTimeFertilized && Carbon::createFromFormat('Y-m-d H:i:s', $lastTimeFertilized->pivot->date)->addDay() < Carbon::now()) {
$status = $plant->plantCharacter['need_fertilizer_phrase_' . $random];
} else {
$status = $plant->plantCharacter['welcome_phrase_' . $random];
}
session()->flash('message', $plant->plantCharacter->name . ': ' . $status);
}
}
return redirect()->route('dashboard');
}
public function run()
{
if (env('DB_DRIVER') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
}
if (env('DB_DRIVER') == 'mysql') {
DB::table(config('access.roles_table'))->truncate();
} else {
//For PostgreSQL or anything else
DB::statement("TRUNCATE TABLE " . config('access.roles_table') . " CASCADE");
}
//Create admin role, id of 1
$role_model = config('access.role');
$admin = new $role_model();
$admin->name = 'Administrator';
$admin->all = true;
$admin->sort = 1;
$admin->created_at = Carbon::now();
$admin->updated_at = Carbon::now();
$admin->save();
//id = 2
$role_model = config('access.role');
$user = new $role_model();
$user->name = 'User';
$user->sort = 2;
$user->created_at = Carbon::now();
$user->updated_at = Carbon::now();
$user->save();
if (env('DB_DRIVER') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
}
/**
* @return mixed
*/
public function showNews()
{
$slug = Request::segment(2);
$news_title = "Not active";
$news_text = "Either this news item is not active, or it does not exist";
$active = 1;
$news_id = 0;
$results = DB::table('news')->where('slug', '=', $slug)->get();
foreach ($results as $result) {
$active = $result->active;
if ($active > 0 || Auth::check() && Auth::user()->hasRole('news')) {
if (Session::get('lang') == null || Session::get('lang') == "en") {
$news_title = $result->title;
$news_text = $result->news_text;
$news_id = $result->id;
} else {
$news_title = $result->title_fr;
$news_text = $result->news_text_fr;
$news_id = $result->id;
}
$news_image = $result->image;
$news_date = $result->news_date;
}
}
return View::make('public.news')->with('news_title', $news_title)->with('news_text', $news_text)->with('page_content', $news_text)->with('active', $active)->with('news_id', $news_id)->with('news_date', $news_date)->with('news_image', $news_image)->with('menu', $this->menu)->with('page_category_id', 0)->with('page_title', $news_title);
}
/**
* Run the Update
*
* @return mixed|void
*/
public function call()
{
$pheal = $this->setScope('char')->getPheal();
foreach ($this->api_info->characters as $character) {
// Get a list of messageIDs that we do not have mail
// bodies for. These ID's will be used to try and
// pull the bodies using this api key
$message_ids = DB::table('character_mail_messages')->where('characterID', $character->characterID)->whereNotIn('messageID', function ($query) {
$query->select('messageID')->from('character_mail_message_bodies');
})->lists('messageID');
// It is possible to provide a comma seperated list
// of messageIDs to the MailBodies endpoint. Pheal
// caches XML's on disk by file name. To prevent file
// names from becoming too long, we will chunk the
// ids we want to update.
foreach (array_chunk($message_ids, 10) as $message_id_chunk) {
$result = $pheal->MailBodies(['characterID' => $character->characterID, 'ids' => implode(',', $message_id_chunk)]);
foreach ($result->messages as $body) {
MailMessageBody::create(['messageID' => $body->messageID, 'body' => $body->__toString()]);
}
}
// Foreach messageID chunk
}
return;
}
public function materiaMaestroEnpalme()
{
$maestroId = Materia::join('maestro_materia', 'materias.id', '=', 'maestro_materia.materia_id')->where('materia_id', '=', Input::get('materia_id'))->select('materia', 'materia_id', 'maestro_id')->first();
$maestroMateria = DB::table('horarios')->join('materias', 'materias.id', '=', 'horarios.materia_id')->join('maestro_materia', 'maestro_materia.materia_id', '=', 'materias.id')->join('maestros', 'maestros.id', '=', 'maestro_materia.maestro_id')->where('hora_id', Input::get('hora_id'))->where('horarios.ciclo_id', Input::get('ciclo_id'))->where('dia_id', Input::get('dia_id'))->where('maestro_id', $maestroId->maestro_id)->get();
//dd($maestroMateria);
return $maestroMateria;
}
public function refresh($town)
{
$town_id = DB::table('towns')->where('town', $town)->first();
$town_id = $town_id->id;
//получить id города
$response = json_decode(file_get_contents('http://api.openweathermap.org/data/2.5/forecast?q=' . $town . '&mode=json&appid=f84ba1064b0ae65792326548686f361c'), true);
// print_r($response);
$id = $response['city']['id'];
$date_today = date("Y-m-d", strtotime("+0 day"));
DB::table('weather')->where('kuupaev', '>=', $date_today)->where('town_id', $town_id)->delete();
for ($i = 0; $i < sizeof($response['list']); $i++) {
$date = date("Y-m-d H:i:s", $response['list'][$i]['dt']);
$temp_min = $response['list'][$i]['main']['temp_min'];
$temp_max = $response['list'][$i]['main']['temp_max'];
$temp_min = round($temp_min - 273.15);
$temp_max = round($temp_max - 273.15);
$weather = new Weather();
$weather->town_id = $id;
$weather->temp_min = $temp_min;
$weather->temp_max = $temp_max;
$weather->kuupaev = $date;
$weather->save();
}
return redirect('weather/' . $town);
}
public function run()
{
DB::table('master_type_bank')->delete();
$data = array(array('name' => 'TABUNGAN', 'info' => '', 'uuid' => uniqid(), 'created_at' => new \DateTime(), 'updated_at' => new \DateTime(), 'createby_id' => 1, 'lastupdateby_id' => 1), array('name' => 'GIRO', 'info' => '', 'uuid' => uniqid(), 'created_at' => new \DateTime(), 'updated_at' => new \DateTime(), 'createby_id' => 1, 'lastupdateby_id' => 1), array('name' => 'DEPOSITO', 'info' => '', 'uuid' => uniqid(), 'created_at' => new \DateTime(), 'updated_at' => new \DateTime(), 'createby_id' => 1, 'lastupdateby_id' => 1));
DB::table('master_type_bank')->insert($data);
$this->command->info('Done [' . __CLASS__ . ']');
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
DB::table('favorites')->whereNotNull('deleted_at')->delete();
Schema::table('favorites', function (Blueprint $table) {
$table->dropColumn('deleted_at');
});
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('tags')->insert(['title' => "camiseta"]);
DB::table('tags')->insert(['title' => "preta"]);
DB::table('tags')->insert(['title' => "branca"]);
DB::table('tags')->insert(['title' => "amarela"]);
}
/**
* Apply the scope to a given Eloquent query builder.
*
* @param \Illuminate\Database\Eloquent\Builder $builder
* @param \Illuminate\Database\Eloquent\Model $model
* @return void
*/
public function apply(Builder $builder, Model $model)
{
if (isset($model->workend)) {
$end = $model->workend;
} else {
$end = 'now';
}
$prefix_person = 'hrps_';
//env('DB_PREFIX_HR_PERSON');
$prefix_empl = 'hres_';
//env('DB_PREFIX_HR_EMPLOYMENT');
$prefix_org = 'hrom_';
//env('DB_PREFIX_HR_ORGANISATION');
$builder->selectraw('CONCAT(' . $prefix_org . 'charts.name, " cabang ", ' . $prefix_org . 'branches.name) as newest_position')->selectraw($prefix_org . 'branches.organisation_id as organisation_id')->selectraw($prefix_org . 'charts.department as newest_department')->selectraw($prefix_empl . 'works.id as newest_work_id')->selectraw($prefix_empl . 'works.nik as newest_nik')->selectraw($prefix_empl . 'works.status as newest_status')->selectraw($prefix_empl . 'works.start as newest_work_start')->selectraw($prefix_empl . 'works.end as newest_work_end')->join(DB::raw($prefix_empl . 'works'), function ($join) use($end, $prefix_empl, $prefix_person) {
$join->on(DB::raw($prefix_person . 'persons.id'), '=', DB::raw($prefix_empl . 'works.person_id'))->where(function ($query) use($end, $prefix_empl) {
$query->where(function ($query) use($end, $prefix_empl) {
$query;
// $query->wherenull( DB::raw($prefix_empl.'works.end'))
// ->orwhere( DB::raw($prefix_empl.'works.end'), '>=', date('Y-m-d H:i:s', strtotime($end)));
})->wherenull(DB::raw($prefix_empl . 'works.deleted_at'));
});
})->join(DB::raw($prefix_org . 'charts'), function ($join) use($prefix_empl, $prefix_org) {
$join->on(DB::raw($prefix_empl . 'works.chart_id'), '=', DB::raw($prefix_org . 'charts.id'))->wherenull(DB::raw($prefix_org . 'charts.deleted_at'));
})->join(DB::raw($prefix_org . 'branches'), function ($join) use($prefix_org) {
$join->on(DB::raw($prefix_org . 'charts.branch_id'), '=', DB::raw($prefix_org . 'branches.id'))->wherenull(DB::raw($prefix_org . 'branches.deleted_at'));
})->groupby(DB::raw($prefix_person . 'persons.id'));
}
public function run()
{
if (env('DB_DRIVER') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
}
if (env('DB_DRIVER') == 'mysql') {
DB::table(config('access.assigned_roles_table'))->truncate();
} elseif (env('DB_DRIVER') == 'sqlite') {
DB::statement("DELETE FROM " . config('access.assigned_roles_table'));
} else {
//For PostgreSQL or anything else
DB::statement("TRUNCATE TABLE " . config('access.assigned_roles_table') . " CASCADE");
}
//Attach admin role to admin user
$user_model = config('auth.model');
$user_model = new $user_model();
$user_model::first()->attachRole(1);
//Attach user role to general user
$user_model = config('auth.model');
$user_model = new $user_model();
$user_model::find(2)->attachRole(2);
if (env('DB_DRIVER') == 'mysql') {
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
}
public function keywords()
{
$limit = 25;
$projections = array('id', 'value');
$keywords = DB::collection('map_reduce_twitter_words')->orderBy('value', 'desc')->paginate($limit, $projections);
return view('keywords')->with(['keywords' => $keywords]);
}
public function save()
{
if (!$this->product_id) {
return Category::find($this->category)->product()->create($this->fields());
}
return DB::table('products')->where('id', $this->product_id)->update(['category_id' => $this->category, 'name' => $this->name, 'type' => $this->type, 'length' => $this->length, 'thickness' => $this->thickness, 'width' => $this->width, 'description' => $this->description, 'hidden' => $this->hidden]);
}
/**
* Returns the sum of all values a metric has by the hour.
*
* @param int $hour
*
* @return int
*/
public function getValuesByHour($hour)
{
$dateTimeZone = SettingFacade::get('app_timezone');
$dateTime = (new Date())->setTimezone($dateTimeZone)->sub(new DateInterval('PT' . $hour . 'H'));
$hourInterval = $dateTime->format('YmdH');
if (Config::get('database.default') === 'mysql') {
if (!isset($this->calc_type) || $this->calc_type == self::CALC_SUM) {
$value = (int) $this->points()->whereRaw('DATE_FORMAT(created_at, "%Y%m%d%H") = ' . $hourInterval)->groupBy(DB::raw('HOUR(created_at)'))->sum('value');
} elseif ($this->calc_type == self::CALC_AVG) {
$value = (int) $this->points()->whereRaw('DATE_FORMAT(created_at, "%Y%m%d%H") = ' . $hourInterval)->groupBy(DB::raw('HOUR(created_at)'))->avg('value');
}
} else {
// Default metrics calculations.
if (!isset($this->calc_type) || $this->calc_type == self::CALC_SUM) {
$queryType = 'sum(metric_points.value)';
} elseif ($this->calc_type == self::CALC_AVG) {
$queryType = 'avg(metric_points.value)';
} else {
$queryType = 'sum(metric_points.value)';
}
$query = DB::select("select {$queryType} as aggregate FROM metrics JOIN metric_points ON metric_points.metric_id = metrics.id WHERE metric_points.metric_id = {$this->id} AND to_char(metric_points.created_at, 'YYYYMMDDHH24') = :timestamp GROUP BY to_char(metric_points.created_at, 'H')", ['timestamp' => $hourInterval]);
if (isset($query[0])) {
$value = $query[0]->aggregate;
} else {
$value = 0;
}
}
if ($value === 0 && $this->default_value != $value) {
return $this->default_value;
}
return $value;
}
public function postSendsms(Request $request)
{
$mobile = Input::get('mobile');
if (!preg_match("/1[3458]{1}\\d{9}\$/", $mobile)) {
// if(!preg_match("/^13\d{9}$|^14\d{9}$|^15\d{9}$|^17\d{9}$|^18\d{9}$/",$mobile)){
//手机号码格式不对
return parent::returnJson(1, "手机号码格式不对" . $mobile);
}
$data = DB::select("select * from members where lifestatus=1 and mobile =" . $mobile);
if (sizeof($data) > 0) {
return parent::returnJson(1, "手机号已注册");
}
$checkCode = parent::get_code(6, 1);
Session::put("m" . $mobile, $checkCode);
$checkCode = Session::get("m" . $mobile);
Log::error("sendsms:session:" . $checkCode);
$msg = "尊敬的用户：" . $checkCode . "是您本次的短信验证码，5分钟内有效.";
// Input::get('msg');
$curl = new cURL();
$serverUrl = "http://cf.lmobile.cn/submitdata/Service.asmx/g_Submit";
$response = $curl->get($serverUrl . "?sname=dlrmcf58&spwd=ZRB2aP8K&scorpid=&sprdid=1012818&sdst=" . $mobile . "&smsg=" . rawurlencode($msg . "【投贷宝】"));
$xml = simplexml_load_string($response);
echo json_encode($xml);
//$xml->State;
// <CSubmitState xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://tempuri.org/">
// <State>0</State>
// <MsgID>1512191953407413801</MsgID>
// <MsgState>提交成功</MsgState>
// <Reserve>0</Reserve>
// </CSubmitState>
// <State>1023</State>
// <MsgID>0</MsgID>
// <MsgState>无效计费条数,号码不规则,过滤[1:186019249011,]</MsgState>
// <Reserve>0</Reserve>
}
