微信の小さいプログラムを分かち合って友達にあげます
29597 ワード
html
js
インタフェース
データベース#データベース#
<button class="fixed-text fixed-button" open-type="share" title=" " hover-class="none"> </button>
js
/**
*
*/
onShareAppMessage: function() {
//
var num = util.create_uuid();
var shareObj = {
title: ' ',
path: '/pages/index/index?origin_from=share&origin_num=' + num,
imageUrl: '/images/share.png'
}
//
util.save_user_share(shareObj.title, shareObj.path, shareObj.imageUrl, num);
return shareObj;
},
/**
* --
*/
onLoad: function(options) {
var that = this;
app.firstload(function(res) {
//
console.log(options)
if (options.origin_from == 'share') {
//
util.update_user_share(options.origin_num);
}
})
},
インタフェース
//
public function share_save() {
$openid = $_REQUEST['openid'];
$title = $_REQUEST['title'];
$path = $_REQUEST['path'];
$img_url = $_REQUEST['img_url'];
$num = $_REQUEST['num'];
//
$username = db('weixin_user')->where(['OpenId' => $openid])->value('NickName');
//
$data['num'] = $num;
$data['openid'] = $openid;
$data['title'] = $title;
$data['path'] = $path;
$data['img_url'] = $img_url;
$data['create_time'] = time();
$data['create_user'] = $username;
$res = db('tf_share')->insert($data);
if ($res != false) {
$return['status'] = 1;
$return['info'] = ' ';
} else {
$return['status'] = 0;
$return['info'] = ' ';
}
exit(json_encode($return));
}
//
public function share_update() {
$openid = $_REQUEST['openid'];
$num = $_REQUEST['num'];
//
$username = db('weixin_user')->where(['OpenId' => $openid])->value('NickName');
//
$share_info = db('tf_share')->where(array('num' => $num))->find();
if (!count($share_info)) {
$return['status'] = 0;
$return['info'] = ' ';
exit(json_encode($return));
}
//
$where['openid'] = $openid;
$where['share_id'] = $share_info['id'];
$share_user_info = db('tf_share_user')->where($where)->find();
if ($share_user_info) {
$data['ip'] = request()->ip();
$data['update_time'] = time();
$data['update_user'] = $username;
$res = db('tf_share_user')->where($where)->update($data);
} else {
$data['share_id'] = $share_info['id'];
$data['openid'] = $openid;
$data['ip'] = request()->ip();
$data['create_time'] = time();
$data['create_user'] = $username;
$res = db('tf_share_user')->insert($data);
}
if ($res != false) {
$return['status'] = 1;
$return['info'] = ' ';
} else {
$return['status'] = 0;
$return['info'] = ' ';
}
exit(json_encode($return));
}
データベース#データベース#
CREATE TABLE `t_tf_share` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' id',
`num` varchar(100) NOT NULL COMMENT ' ',
`openid` varchar(50) NOT NULL COMMENT ' openid',
`title` varchar(100) NOT NULL COMMENT ' ',
`img_url` varchar(255) NOT NULL COMMENT ' ',
`path` varchar(255) NOT NULL COMMENT ' ',
`create_time` int(11) DEFAULT NULL COMMENT ' ',
`create_user` varchar(100) DEFAULT NULL COMMENT ' ',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `source` (`num`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=' ';
CREATE TABLE `t_tf_share_user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' id',
`openid` varchar(50) NOT NULL COMMENT ' openid',
`share_id` int(11) DEFAULT NULL COMMENT ' id',
`ip` varchar(20) NOT NULL COMMENT ' ip ',
`create_time` int(11) DEFAULT NULL COMMENT ' ',
`create_user` varchar(100) DEFAULT NULL COMMENT ' ',
`update_time` int(11) DEFAULT NULL COMMENT ' ',
`update_user` varchar(100) DEFAULT NULL COMMENT ' ',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=' ( )';
CREATE TABLE `t_weixin_user` (
`Id` int(11) NOT NULL AUTO_INCREMENT COMMENT ' id',
`OpenId` varchar(50) DEFAULT NULL COMMENT ' OpenId',
`FakeId` varchar(50) DEFAULT NULL COMMENT ' ( )',
`NickName` varchar(100) DEFAULT NULL COMMENT ' ',
`ReMarkName` varchar(50) DEFAULT NULL COMMENT ' ',
`Username` varchar(50) DEFAULT NULL COMMENT ' ',
`Signature` text COMMENT ' ',
`Country` varchar(50) DEFAULT NULL COMMENT ' ',
`Province` varchar(50) DEFAULT NULL COMMENT ' ',
`City` varchar(50) DEFAULT NULL COMMENT ' ',
`Sex` int(11) DEFAULT NULL COMMENT ' ',
`GroupId` int(11) DEFAULT NULL COMMENT ' ',
`HeadImg` varchar(150) DEFAULT NULL COMMENT ' ',
`Status` int(11) DEFAULT NULL COMMENT ' :0 ,1 ,2 ',
`Source` varchar(65) DEFAULT '0' COMMENT ' ID',
`UnionId` varchar(50) DEFAULT NULL COMMENT ' Id',
`CompanyId` int(11) DEFAULT NULL COMMENT ' id( :t_company)',
`ConfigId` int(11) DEFAULT NULL COMMENT ' id( :t_config id)',
`CreateTime` int(11) DEFAULT NULL COMMENT ' ',
`UpdateTime` int(11) DEFAULT NULL COMMENT ' User ',
PRIMARY KEY (`Id`) USING BTREE,
KEY `CompanyId` (`ConfigId`) USING BTREE,
KEY `OpenId` (`OpenId`) USING BTREE,
KEY `UninId_ConfigId` (`UnionId`,`ConfigId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=' ';