public function addDevice()
{
$m_scene = M('device');
$mapp = array();
$mapp['userid_int'] = session('userid');
$mapp['delete_int'] = 1;
$delete_count = $m_scene->where($mapp)->count();
$mapp2 = array();
$mapp2['userid_int'] = session('userid');
$create_count = $m_scene->where($mapp2)->count();
$sum = $create_count - $delete_count;
if (session('scene_times') <= $sum) {
echo json_encode(array("success" => true, "code" => 1006, "msg" => session('scene_times'), "obj" => null, "map" => null, "list" => null));
return;
}
$m_scenepage = M('scenepage');
$datas = $_POST;
$datainfo['scenecode_varchar'] = 'U' . (date('y', time()) - 9) . date('m', time()) . randorderno(6, -1);
$datainfo['scenename_varchar'] = $datas['name'];
$datainfo['movietype_int'] = $datas['pageMode'];
$datainfo['scenetype_int'] = intval($datas['type']);
$datainfo['ip_varchar'] = get_client_ip();
$datainfo['thumbnail_varchar'] = "default_thum.jpg";
$datainfo['userid_int'] = session('userid');
$datainfo['createtime_time'] = date('y-m-d H:i:s', time());
$result1 = $m_scene->add($datainfo);
//var_dump($result1);exit;
if ($result1) {
$datainfo2['scenecode_varchar'] = $datainfo['scenecode_varchar'];
$datainfo2['sceneid_bigint'] = $result1;
$datainfo2['content_text'] = "[]";
$datainfo2['properties_text'] = 'null';
$datainfo2['userid_int'] = session('userid');
$result2 = $m_scenepage->add($datainfo2);
// create page and device mapping
if ($result2) {
$m_deviceScene = M('device_scene');
$deviceSceneInfo['device_id'] = intval($datas['deviceID']);
$deviceSceneInfo['sceneid_bigint'] = $result1;
$result3 = $m_deviceScene->add($deviceSceneInfo);
echo json_encode(array("success" => true, "code" => 200, "msg" => "success", "obj" => $result1, "map" => null, "list" => null));
}
} else {
exit;
}
}
public function addscenebysys()
{
$m_scene = M('Scene');
$m_scenepage = M('scenepage');
$datas = $_POST;
$wheresysscene['userid_int'] = 0;
$wheresysscene['sceneid_bigint'] = I('post.id', 0);
$_scene_sysinfo = $m_scene->where($wheresysscene)->select();
$datainfo['scenecode_varchar'] = date('y', time()) - 9 . date('m', time()) . date('d', time()) . randorderno(10, -1);
$datainfo['scenename_varchar'] = $datas['name'];
$datainfo['movietype_int'] = $_scene_sysinfo[0]['movietype_int'];
$datainfo['scenetype_int'] = intval($datas['type']);
$datainfo['ip_varchar'] = get_client_ip();
$datainfo['thumbnail_varchar'] = $_scene_sysinfo[0]['thumbnail_varchar'];
$datainfo['musicurl_varchar'] = $_scene_sysinfo[0]['musicurl_varchar'];
$datainfo['musictype_int'] = $_scene_sysinfo[0]['musictype_int'];
$datainfo['fromsceneid_bigint'] = $wheresysscene['sceneid_bigint'];
$datainfo['userid_int'] = session('userid');
$datainfo['createtime_time'] = date('y-m-d H:i:s', time());
$result1 = $m_scene->add($datainfo);
if ($result1) {
$m_scene->where($wheresysscene)->setInc('usecount_int');
$wheresyspage['userid_int'] = 0;
$wheresyspage['sceneid_bigint'] = I('post.id', 0);
$_scene_syspageinfo = $m_scenepage->where($wheresyspage)->select();
foreach ($_scene_syspageinfo as $vo) {
$datainfo2['scenecode_varchar'] = $datainfo['scenecode_varchar'];
$datainfo2['sceneid_bigint'] = $result1;
$datainfo2['content_text'] = $vo['content_text'];
$datainfo2['pagecurrentnum_int'] = $vo['pagecurrentnum_int'];
$datainfo2['userid_int'] = session('userid');
$datainfo2['createtime_time'] = date('y-m-d H:i:s', time());
$result2 = $m_scenepage->add($datainfo2);
}
echo json_encode(array("success" => true, "code" => 200, "msg" => "success", "obj" => $result1, "map" => null, "list" => null));
} else {
exit;
}
}
public function addscenebycopy()
{
$m_scene = M('Scene');
$mapp = array();
$mapp['userid_int'] = session('userid');
$mapp['delete_int'] = 1;
$delete_count = $m_scene->where($mapp)->count();
$mapp2 = array();
$mapp2['userid_int'] = session('userid');
$create_count = $m_scene->where($mapp2)->count();
$sum = $create_count - $delete_count;
if (session('scene_times') <= $sum) {
echo json_encode(array("success" => true, "code" => 1006, "msg" => session('scene_times'), "obj" => null, "map" => null, "list" => null));
return;
}
$m_scenepage = M('scenepage');
$m_scenedata = M('scenedata');
$wheresysscene['userid_int'] = session('userid');
$wheresysscene['sceneid_bigint'] = I('get.id', 0);
$_scene_sysinfo = $m_scene->where($wheresysscene)->select();
$datainfo['scenecode_varchar'] = 'U' . (date('y', time()) - 9) . date('m', time()) . date('d', time()) . randorderno(10, -1);
$datainfo['scenename_varchar'] = '副本-' . $_scene_sysinfo[0]['scenename_varchar'];
$datainfo['movietype_int'] = $_scene_sysinfo[0]['movietype_int'];
$datainfo['scenetype_int'] = $_scene_sysinfo[0]['scenetype_int'];
$datainfo['ip_varchar'] = get_client_ip();
$datainfo['thumbnail_varchar'] = $_scene_sysinfo[0]['thumbnail_varchar'];
$datainfo['musicurl_varchar'] = $_scene_sysinfo[0]['musicurl_varchar'];
$datainfo['musictype_int'] = $_scene_sysinfo[0]['musictype_int'];
$datainfo['fromsceneid_bigint'] = $wheresysscene['sceneid_bigint'];
$datainfo['userid_int'] = session('userid');
$datainfo['createtime_time'] = date('y-m-d H:i:s', time());
$result1 = $m_scene->add($datainfo);
if ($result1) {
$m_scene->where($wheresysscene)->setInc('usecount_int');
$wheresyspage['userid_int'] = session('userid');
$wheresyspage['sceneid_bigint'] = I('get.id', 0);
$_scene_syspageinfo = $m_scenepage->where($wheresyspage)->select();
foreach ($_scene_syspageinfo as $vo) {
$datainfo2['scenecode_varchar'] = $datainfo['scenecode_varchar'];
$datainfo2['sceneid_bigint'] = $result1;
$datainfo2['content_text'] = $vo['content_text'];
$datainfo2['properties_text'] = 'null';
$datainfo2['pagecurrentnum_int'] = $vo['pagecurrentnum_int'];
$datainfo2['userid_int'] = session('userid');
$datainfo2['createtime_time'] = date('y-m-d H:i:s', time());
$result2 = $m_scenepage->add($datainfo2);
$wheredata['userid_int'] = session('userid');
$wheredata['sceneid_bigint'] = $vo['sceneid_bigint'];
$wheredata['pageid_bigint'] = $vo['pageid_bigint'];
$_scenedatasys_list = $m_scenedata->where($wheredata)->select();
foreach ($_scenedatasys_list as $vo2) {
$dataList[] = array('sceneid_bigint' => $result1, 'pageid_bigint' => $result2, 'elementid_int' => $vo2['elementid_int'], 'elementtitle_varchar' => $vo2['elementtitle_varchar'], 'elementtype_int' => $vo2['elementtype_int'], 'userid_int' => session('userid'));
}
}
if (count($dataList) > 0) {
$m_scenedata->addAll($dataList);
}
echo json_encode(array("success" => true, "code" => 200, "msg" => "success", "obj" => $result1, "map" => null, "list" => null));
} else {
exit;
}
}
function copytos()
{
$m_scene = M('Scene');
$m_scenepage = M('scenepage');
$m_scenedata = M('scenedata');
//$wheresysscene['userid_int'] = session('userid');
$wheresysscene['sceneid_bigint'] = I('get.id', 0);
$_scene_sysinfo = $m_scene->where($wheresysscene)->select();
$datainfo['scenecode_varchar'] = 'U' . (date('y', time()) - 9) . date('m', time()) . date('d', time()) . randorderno(10, -1);
$datainfo['scenename_varchar'] = '副本-' . $_scene_sysinfo[0]['scenename_varchar'];
$datainfo['movietype_int'] = $_scene_sysinfo[0]['movietype_int'];
$datainfo['scenetype_int'] = $_scene_sysinfo[0]['scenetype_int'];
$datainfo['ip_varchar'] = get_client_ip();
$datainfo['thumbnail_varchar'] = $_scene_sysinfo[0]['thumbnail_varchar'];
$datainfo['musicurl_varchar'] = $_scene_sysinfo[0]['musicurl_varchar'];
$datainfo['musictype_int'] = $_scene_sysinfo[0]['musictype_int'];
$datainfo['fromsceneid_bigint'] = $wheresysscene['sceneid_bigint'];
$datainfo['userid_int'] = 0;
$datainfo['createtime_time'] = date('y-m-d H:i:s', time());
$result1 = $m_scene->add($datainfo);
if ($result1) {
$m_scene->where($wheresysscene)->setInc('usecount_int');
$wheresyspage['sceneid_bigint'] = I('get.id', 0);
$_scene_syspageinfo = $m_scenepage->where($wheresyspage)->select();
foreach ($_scene_syspageinfo as $vo) {
$datainfo2['scenecode_varchar'] = $datainfo['scenecode_varchar'];
$datainfo2['sceneid_bigint'] = $result1;
$datainfo2['content_text'] = $vo['content_text'];
$datainfo2['properties_text'] = 'null';
$datainfo2['pagecurrentnum_int'] = $vo['pagecurrentnum_int'];
$datainfo2['userid_int'] = 0;
$datainfo2['createtime_time'] = date('y-m-d H:i:s', time());
$result2 = $m_scenepage->add($datainfo2);
//$wheredata['userid_int'] = session('userid');
$wheredata['sceneid_bigint'] = $vo['sceneid_bigint'];
$wheredata['pageid_bigint'] = $vo['pageid_bigint'];
$_scenedatasys_list = $m_scenedata->where($wheredata)->select();
foreach ($_scenedatasys_list as $vo2) {
$dataList[] = array('sceneid_bigint' => $result1, 'pageid_bigint' => $result2, 'elementid_int' => $vo2['elementid_int'], 'elementtitle_varchar' => $vo2['elementtitle_varchar'], 'elementtype_int' => $vo2['elementtype_int'], 'userid_int' => 0);
}
}
if (count($dataList) > 0) {
$m_scenedata->addAll($dataList);
}
$this->success('操作成功', '/adminc.php?c=scene');
} else {
$this->error('出错啦', '?c=scene');
}
}
public function createsysscene()
{
$jsonstr = '';
$jsonresult = json_decode($jsonstr, true);
foreach ($jsonresult['list'] as $v) {
$data = file_get_contents('http://e.wesambo.com/' . $v['image']['imgSrc']);
$filetime = time();
$filename1 = md5($v['image']['imgSrc']);
$filename = $filename1 . '.' . substr($v['image']['imgSrc'], -3, 3);
//生成文件名，
$fp = @fopen('./Uploads/syspic/scene/' . $filename, "w");
//以写方式打开文件
@fwrite($fp, $data);
//
fclose($fp);
//完工，哈
if ($v['image']['bgAudio']['url'] != "") {
$data = file_get_contents('http://e.wesambo.com/' . $v['image']['bgAudio']['url']);
$filetime = time();
$filename1 = md5($v['image']['bgAudio']['url']);
$filenameaudio = $filename1 . '.' . substr($v['image']['bgAudio']['url'], -3, 3);
//生成文件名，
$fp = @fopen('./Uploads/syspic/mp3/' . $filenameaudio, "w");
//以写方式打开文件
@fwrite($fp, $data);
//
fclose($fp);
//完工，哈
$datainfo['musicurl_varchar'] = 'syspic/mp3/' . $filenameaudio;
} else {
$bgdatainfo['musicurl_varchar'] = '';
}
$model = M('scene');
$datainfo['scenecode_varchar'] = 'S' . randorderno(10, -1);
$datainfo['scenename_varchar'] = $v['name'];
$datainfo['movietype_int'] = $v['pageMode'];
$datainfo['ip_varchar'] = '127.0.0.1';
$datainfo['thumbnail_varchar'] = 'syspic/scene/' . $filename;
$datainfo['userid_int'] = 0;
$datainfo['createtime_time'] = date('y-m-d H:i:s', time());
$datainfo['scenetype_int'] = $v['type'];
$datainfo['biztype_int'] = 105;
$datainfo['tagid_int'] = 66;
$model->add($datainfo);
echo $datainfo['scenecode_varchar'] . '<br>';
}
}
public function index()
{
$cs = $_GET['cs'];
$user = M("scene");
//die(var_dump($cs));
$where['eqcode'] = $cs;
$code = $user->where($where)->select();
$url = 'http://s2.eqxiu.com/eqs/s/' . $_GET['cs'];
$da = $this->GetCurl($url);
$img = './Uploads/syspic/scene/';
$img2 = './Uploads/';
$mp3 = './Uploads/syspic/mp3/';
$resp = json_decode($da, true);
if (empty($code) and $resp[obj][name] !== '该场景已关闭') {
preg_match_all("/((group1\\/\\w+\\/\\w+\\/\\w+\\/\\w+(-\\w+)*+.(gif|jpg|jpeg|png|bmp)))/isu", $da, $array);
$src2 = 'syspic/scene/';
$src3 = preg_replace("/(group1\\/\\w+\\/\\w+\\/\\w+\\/)/", $src2, $da);
$resp2 = json_decode($src3, true);
foreach ($array[0] as $key => $var) {
$urls[$key] = pathinfo($array[0][$key]);
$this->save_pic('http://res.eqxiu.com/' . $var, $img);
}
$data['scenename_varchar'] = $resp['obj']['name'];
$data['scenecode_varchar'] = 'S' . (date('y', time()) - 9) . date('m', time()) . randorderno(6, -1);
$data['eqid_int'] = $resp['obj']['id'];
$data['eqcode'] = $resp['obj']['code'];
$data['createtime_time'] = date('Y-m-d H:i:s', time());
$data['showstatus_int'] = 1;
$data['movietype_int'] = 0;
$data['userid_int'] = 0;
if (!empty($resp['obj']['image']['bgAudio']['url'])) {
if (preg_match('|^http://|', $resp['obj']['image']['bgAudio']['url'])) {
$mp = $resp['obj']['image']['bgAudio']['url'];
} elseif (isset($resp['obj']['image']['bgAudio']['url'])) {
$mp = 'http://res.eqxiu.com/' . $resp['obj']['image']['bgAudio']['url'];
}
$data['musicurl_varchar'] = 'syspic/mp3/' . $this->save_pic($mp, $mp3);
} else {
}
$pic1 = 'http://res.eqxiu.com/' . $resp['obj']['image']['imgSrc'];
$data['thumbnail_varchar'] = 'syspic/scene/' . $this->save_pic($pic1, $img);
$data['scenetype_int'] = $resp['obj']['type'];
$data['is_tpl'] = 1;
$data['desc_varchar'] = $resp['obj']['description'];
$data['biztype_int'] = $resp['obj']['type'];
$data['musictype_int'] = $resp['obj']['image']['bgAudio']['type'];
$data['musictype_int'] = empty($resp['obj']['image']['bgAudio']['type']) ? 'null' : $data['musictype_int'];
if ($lastInsId = $user->add($data)) {
echo json_encode(array("msg" => "成功采集", "url" => 'http://' . $_SERVER['HTTP_HOST'] . '/v-' . $data['scenecode_varchar']));
} else {
die(var_dump("数据写入错误"));
echo json_encode(array("msg" => "数据写入错误"));
}
$dd = M("scenepage");
$de['sceneid_bigint'] = $lastInsId;
$de['scenecode_varchar'] = $resp2['obj']['code'];
$de['createtime_time'] = date('Y-m-d H:i:s', time());
$de['content_text'] = '';
$de['pagename_varchar'] = 'admin';
$de['userid_int'] = '0';
$de['properties_text'] = 'null';
foreach ($resp2['list'] as $k => $var) {
$de['content_text'] = json_encode($var['elements']);
$de['pagecurrentnum_int'] = $k + 1;
$dd->add($de);
}
} elseif (isset($_GET['cpic'])) {
$dd = M("scenepage");
$where['sceneid_bigint'] = $_GET['id'];
$data = $dd->where($where)->field('content_text')->select();
} else {
if (!empty($code[0][scenecode_varchar])) {
echo json_encode(array("msg" => "已经存在", "url" => 'http://' . $_SERVER['HTTP_HOST'] . '/v-' . $code[0][scenecode_varchar]));
} else {
echo json_encode(array("msg" => "参数不对"));
}
}
}
