がとらぼ

CREATE TABLE timelog (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`nid` varchar(16) NOT NULL,
`dtime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`finout` bit(1) NOT NULL DEFAULT 0,
`flag` bit(1) NOT NULL DEFAULT 1,
PRIMARY KEY (id)
) ENGINE=InnoDB;

CREATE TABLE card (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`nid` varchar(16) NOT NULL,
`uid` int(10) NOT NULL,
`stdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`endate` datetime NOT NULL DEFAULT '2199-12-31 23:59:59',
`flag` bit(1) NOT NULL DEFAULT 1,
PRIMARY KEY (id)
) ENGINE=InnoDB;

CREATE TABLE user (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`uname` varchar(32) NOT NULL,
`uruby` varchar(32) NOT NULL,
`stdate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`endate` datetime NOT NULL DEFAULT '2199-12-31 23:59:59',
`flag` bit(1) NOT NULL DEFAULT 1,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE junk (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`nid` varchar(16) NOT NULL,
`dtime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB;

<?php
header( 'Expires: Fri, 1 Jab 2010 00:00:00 GMT' );
header( 'Last-Modified: ' . gmdate( 'D, d M Y H:i:s' ) . ' GMT' );
header( 'Cache-Control: no-store, no-cache, must-revalidate' );
header( 'Cache-Control: post-check=0, pre-check=0', false );
header( 'Pragma: no-cache' );

$json_string = file_get_contents('php://input');
$data = json_decode($json_string);
if (json_last_error() != JSON_ERROR_NONE){
    echo "丌止てじ";
    exit;
}
$nid = $data->nid;

$dsn = 'mysql:dbname=timerecorder;host=localhost;charset=utf8mb4';
$user = 'timemgr';         //MySQL甧timemgrァオゥヲデ
$password = 'バジヮ・ト';    //MySQL甧timemgrァオゥヲデねバジヮ・ト
$conn = new PDO($dsn, $user, $password);
//$conn->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$sql = "select * from card 
            where nid = '" . $nid . "' 
                and stdate < NOW() 
                and endate > NOW() 
                and flag = 1;";

$stmt = $conn->query($sql);
$results = $stmt->fetchall();
if (empty($results)){
    $sql = "insert into junk 
                (nid) 
                value 
                ('" . $nid . "');";

    $conn->exec($sql);
    $msg = "までぅれぎオ・トてじ";
} else {
    foreach ($results as $row) {
    $uid = $row['uid'];
    }
    $sql = "SELECT * FROM user 
                where id = '" . $uid . "' 
                    and stdate < NOW() 
                    and endate > NOW() 
                    and flag = 1;";

    $stmta = $conn->query($sql);
    $resultsa = $stmta->fetchall();
    if (empty($resultsa)){
        $msg = "ュ・サ・までぅれぎ";
    } else {
        //令上月劸オ・トね堳吇ね凥琅
        foreach ($resultsa as $rowa) {
            $uname = $rowa['uname'];
            $uruby = $rowa['uruby'];
        }
        //ゾィミレク凥琅
        //nidね替絁託錱ゑ碹誌
        $sql = "select * from timelog 
                    where nid = '" . $nid . "' 
                        and dtime < NOW() 
                        and flag = 1 
                    order by dtime desc limit 1;";

        $stmta = $conn->query($sql);
        $resultsa = $stmta->fetchall();
        if (empty($resultsa)){
        $finout = 1; //託錱か焠ぐるは凹勣=1およ
            $dtime = '2000/01/01 00:00:00';
            $msg = $uruby . "ごを、ざやぢがを。";
        } else {
            foreach ($resultsa as $rowa) {
                $lid = $rowa['id'];
                $dtime = $rowa['dtime'];
                $finout = $rowa['finout']; //bitオヨミね倣ね扰ぃ覀泧愎
            }
            if($finout == 1){ //盳剌ね月劸ルゲ・トか凹勣
                $finout = 0;
                //剌囝ね託錱か凹勣 旤仗ゑぽぞぃてぃぞよ譥呉
                if (mktime(0,0,0) > strtotime($dtime)){
                    $msg = $uruby . "ごを、ぞぃがを。ざやぢがをかがねぅてじ。おぎなをざづぎたごぃ。";
                } else {
                    $msg = $uruby . "ごを、ぞぃがを";
                }
            } else { //盳剌ね月劸ルゲ・トか迿勣
                $finout = 1;
                //剌囝ね託錱か迿勣 ぜるか末旤どよ譥呉
                if (strtotime($dtime) > strtotime(date("Y/m/d 00:00:00"))){
                    $msg = $uruby . "ごを、ざやぢがを。せをおぃねぞぃがをかぺをしってじ。おぎなをざづ上ごぃ。";
                } else {
                    $msg = $uruby . "ごを、ざやぢがを。";
                }
            }
        }
        //替絁託錱か30科令冄ね堳吇の替絁ゑ叕ら涇ざ
        // ごよな仉囝刅め焠劸ルゲ・トでざづ発錱(でなおぎ託錱のじり)
        if ((time() - strtotime($dtime)) < 30 ){
            $sql = "update timelog 
                        set flag = 0 
                            where id = $lid;";

            $conn->exec($sql);
            $sql = "insert into timelog 
                        (nid, finout, flag) 
                        value 
                        ('" . $nid . "', " . $finout . ", 0);";

            $conn->exec($sql);
            if ($finout = 0){
                $sfinout = "ざやぢがを";
            } else {
                $sfinout = "ぞぃがを";
            }
            $msg = $uruby. "ごを、30科ぃどぃね" . $sfinout . "、でらぐざ";
        } else {
            //託錱ゑ仗ぐり
            $sql = "insert into timelog 
                        (nid, finout) 
                        value 
                        ('" . $nid . "', " . $finout . ");";

            $conn->exec($sql); 
        }
    }
}
unset($conn);
echo $msg;
?>

#!/bin/sh
HOSTPATH=example.com/timerecorder/db_recorder.php
LOGFILE=/var/log/card.log
TMP=/tmp/tmp.wav

echo none > /sys/class/leds/nanopi:blue:status/trigger

while :
do
    nid=$(nfc-poll | grep NFCID2 | cut -d: -f 2 | sed 's/ //g')

    if ! [ x"$nid" = x ];then
        echo `date '+%Y/%m/%d %H:%M:%S'` $nid >>$LOGFILE
        RESP=`curl http://$HOSTPATH -s -X POST -H "Content-Type: application/json" -d '{"nid": "'$nid'"}' 2&>/dev/null`
        echo heartbeat > /sys/class/leds/nanopi:blue:status/trigger
        echo $RESP
        echo $RESP | open_jtalk -m /usr/share/hts-voice/mei/mei_normal.htsvoice -x /var/lib/mecab/dic/open-jtalk/naist-jdic -ow $TMP && aplay --quiet $TMP
        rm -f $TMP
        echo none > /sys/class/leds/nanopi:blue:status/trigger
        sleep 1
    fi
done