向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除|赢在IT，Playin' with IT,Focus on Killer Application,Marketing Meets Technology.

select  information.group, information.connection, information.productid, information.invitetype,relation.id, relation.owneruid, relation.otheruid, relation.type, relation.status, relation.infoid from relation  FORCE INDEX (oo,infoid) left join information   FORCE INDEX (g_i_c) on relation.infoid=information.infoid where information.group = 0 and relation.owneruid = 1257432324 and relation.type = 1;

select  SQL_NO_CACHE  information.group, information.connection, information.productid, information.invitetype,relation.id, relation.owneruid, relation.otheruid, relation.type, relation.status, relation.infoid from relation  FORCE INDEX (oo,infoid) left join information   FORCE INDEX (g_i_c) on relation.infoid=information.infoid where information.group = 0 and relation.owneruid = 1257432324 and relation.type = 1;

select SQL_NO_CACHE  relation.id, relation.owneruid, relation.otheruid, relation.type, relation.status, relation.infoid, information.group, information.connection, information.productid, information.invitetype from relation IGNORE INDEX (PRIMARY,otc,oo,ots,uniq_key,infoid) left join information IGNORE INDEX (PRIMARY,g_i_c)  on relation.infoid=information.infoid where information.group = 0 and relation.owneruid = 1257432324 and relation.type = 1;

select SQL_NO_CACHE SQL_BUFFER_RESULT  relation.id, relation.owneruid, relation.otheruid, relation.type, relation.status, relation.infoid, information.group, information.connection, information.productid, information.invitetype from relation left join information on relation.infoid=information.infoid where information.group = 0 and relation.owneruid = 1257432324 and relation.type = 1;

GRANT ALL ON DB_***team2010***.* TO kary@localhost IDENTIFIED BY "zu9UWep**";
FLUSH PRIVILEGES ;
mysql -ukary -pzu9UWepr

#! /usr/local/php/bin/php
<?
set_time_limit(0);
while(1)
{
@fopen("test_".time().".txt","w");
sleep(30);
}
?>

$ ps
PID TT STAT      TIME COMMAND
82374 p3 Ss     0:00.14 -bash (bash)
82510 p3 S      0:00.06 /usr/local/php/bin/php /home/heiyeluren/php_daemon1.php
82528 p3 R+     0:00.00 ps

$ kill -9 82510
[1]+ Killed                  nohup /home/heiyeluren/php_daemon1.php

$ vi php_daemon2.php

#! /usr/local/php/bin/php
<?php
/* 设置不显示任何错误 */
error_reporting(0);

/* 脚本超时为无限 */
set_time_limit(0);

/* 开始固定清除 */
ob_implicit_flush();

/* 本机的IP和需要开放的端口 */
$address = '192.168.0.1';
$port = 10000;

/* 产生一个Socket */
if (($sock = socket_create(AF_INET, SOCK_STREAM, SOL_TCP)) < 0) {
    echo "socket_create() failed: reason: " . socket_strerror($sock) . "\n";
}

/* 把IP地址端口进行绑定 */
if (($ret = socket_bind($sock, $address, $port)) < 0) {
    echo "socket_bind() failed: reason: " . socket_strerror($ret) . "\n";
}

/* 监听Socket连接 */
if (($ret = socket_listen($sock, 5)) < 0) {
    echo "socket_listen() failed: reason: " . socket_strerror($ret) . "\n";
}

/* 永远循环监接受用户连接 */
do {
    if (($msgsock = socket_accept($sock)) < 0) {
        echo "socket_accept() failed: reason: " . socket_strerror($msgsock) . "\n";
        break;
    }
    /* 发送提示信息给连接上来的用户 */
    $msg = "==========================================\r\n" .
" Welcome to the PHP Test Server. \r\n\r\n".
        " To quit, type 'quit'. \r\n" .
" To shut down the server type 'shutdown'.\r\n" .
" To get help message type 'help'.\r\n" .
"==========================================\r\n" .
"php> ";
    socket_write($msgsock, $msg, strlen($msg));

    do {
        if (false === ($buf = socket_read($msgsock, 2048, PHP_NORMAL_READ))) {
            echo "socket_read() failed: reason: " . socket_strerror($ret) . "\n";
            break 2;
        }
        if (!$buf = trim($buf)) {
            continue;
        }
   /* 客户端输入quit命令时候关闭客户端连接 */
        if ($buf == 'quit') {
            break;
        }
   /* 客户端输入shutdown命令时候服务端和客户端都关闭 */
        if ($buf == 'shutdown') {
            socket_close($msgsock);
            break 2;
        }
   /* 客户端输入help命令时候输出帮助信息 */
   if ($buf == 'help') {
    $msg = " PHP Server Help Message \r\n\r\n".
    " To quit, type 'quit'. \r\n" .
    " To shut down the server type 'shutdown'.\r\n" .
    " To get help message type 'help'.\r\n" .
    "php> ";
    socket_write($msgsock, $msg, strlen($msg));
    continue;
   }
   /* 客户端输入命令不存在时提示信息 */
        $talkback = "PHP: unknow command '$buf'.\r\nphp> ";
        socket_write($msgsock, $talkback, strlen($talkback));
        echo "$buf\n";
    } while (true);
    socket_close($msgsock);
} while (true);

/* 关闭Socket连接 */
socket_close($sock);
?>

$ chmod +x /home/heiyeluren/php_daemon2.php

$ nohup /home/heiyeluren/php_daemon2.php &

C:\>telnet 192.168.0.1 10000

==========================================
Welcome to the PHP Test Server.

To quit, type 'quit'.
To shut down the server type 'shutdown'.
To get help message type 'help'.
==========================================

php> asdf
PHP: unknow command 'asdf'.

执行help命令可以获取帮助：

php> help
PHP Server Help Message

To quit, type 'quit'.
To shut down the server type 'shutdown'.
To get help message type 'help'.

<?php
class a
{
  private $inHandle;
    public function getHandle($handle='')
    {  
        if ('' != $handle)
        {  
            $this->inHandle = $handle;
            return ;
        }  
        elseif ('' != $this->inHandle)
        {  
            return;
        }  
        $this->inHandle = new b();
        return;
    }
  public function use_b_class($num)
  {  //调用b类的：need_mock方法，假如是外部资源，为此需要mock
    $value = $this->inHandle->need_mock($num);
    $result = $value;
    return $result;    
  }  
}
?>

<?php
class b
{  protected $a = 0;
  protected $b = 0;
  public function __construct($a,$b)
  {
    $this->a = $a;
    $this->b = $b;
    echo $this->b;    
  }
  public function  need_mock($a)
  {
    $b = $this->a+$a;
    return $b;
  }
}
?>

<?php
require_once 'a.php';
require_once 'b.php';
require_once 'PHPUnit/Framework/TestCase.php';
/**
* a test case.
*/
class aTest extends PHPUnit_Framework_TestCase {  
  /**
   * @var a
   */
  private $a;  
  /**
   * Prepares the environment before running a test.
   */
  protected function setUp() {
    parent::setUp ();    
    // TODO Auto-generated aTest::setUp()
    $this->a = new a(/* parameters */);
  }  
  /**
   * Cleans up the environment after running a test.
   */
  protected function tearDown() {
    // TODO Auto-generated aTest::tearDown()
    $this->a = null;    
    parent::tearDown ();
  }
  
  /**
   * Constructs the test case.
   */
  public function __construct() {
    // TODO Auto-generated constructor
  }
  
  /**
   * Tests a->getHandle()
   */
  public function testGetHandle() {
    // TODO Auto-generated aTest->testGetHandle()
    $this->markTestIncomplete ( "getHandle test not implemented" );    
    $this->a->getHandle(/* parameters */);  
  }
  
  /**
   * Tests a->use_b_class()
   */
  public function testUse_b_class() {
    // TODO Auto-generated aTest->testUse_b_class()
    //$this->markTestIncomplete ( "use_b_class test not implemented" );
    
    //$this->a->use_b_class(/* parameters */);
    $a = array(1,"第二个参数");//注意：必须传array(构造函数参数1，构造函数参数2，构造函数参数3)
    $stub = $this->getMock('b', array('need_mock'),$a);
        $stub->expects($this->any())
             ->method('need_mock')
             ->with(      
                   $this->equalTo( 1 )//传入一个参数
                   )
             ->will($this->returnValue(11));//设定返回为11
        $this->a->getHandle($stub);//传入经过mock的对象      
        echo $this->a->use_b_class(1);
        $this->assertEquals($this->a->use_b_class(1) , 11 );
        $this->assertEquals(array(array(0,1,2)),array(array(0,1,2)));//必须是所谓的二维数组，否则出错
  
  }

}

#include<REG51.h>



void init(void)
{
TMOD=0x20;
TH1=0xE8;
TL1=0xE8;
PCON=0x00;
TR1=1;
SCON=0x50;
}


void checkout(unsigned int para)
{   unsigned int paracheck=para;
redo:   if(SBUF!=paracheck)
        SBUF=0xFF;
     while(TI==0);
  TI=0;
  while(RI==0);
  RI=0;
        if(SBUF!=paracheck)
  goto redo;
  
      else SBUF=0xBB;
  while(TI==0);
  TI=0;



}


void ledflash(unsigned char flashnum)
{
   unsigned char i,k;
   for(i=flashnum;i>0;i--)
     for(k=200;k>0;k--)
  {
  ;
  P0=0x00;
  P0=0xFF;
     }
}



void get()
{  unsigned int getnum;
  while(RI==0);
  RI=0;
  while((getnum=SBUF)!=0xCC)
  {
  if(getnum%4==0)
    {ledflash(getnum);
       SBUF=0xBB;
    goto check;}
  else
     SBUF=0xFF;
check: while(TI==0);
  TI=0;
     while(RI==0);
      RI=0;
}

}





void ledon()
{
P0=0x00;
P0=0xFF;
}


void ledoff()
{
P0=0xFF;
P0=0x00;
}



void main(void)
{

while(1)
{
init();
checkout(0xAA);
ledon();
get();
checkout(0xCC);
ledoff();
}
}

#include<REG51.h>






void init(void)
{
TMOD=0x20;
TH1=0xE8;
TL1=0xE8;
PCON=0x00;
TR1=1;
SCON=0x50;

}




void checkout(unsigned int para)
{   unsigned int paracheck;
           paracheck=para;
redo:      SBUF=paracheck;
     while(TI==0);
     TI=0;
     while(RI==0);
     RI=0;
     if(SBUF!=0xBB)
     goto redo;
}



void sent(void)
{unsigned char i;
      checkout(0xAA);

    
  
   for( i=0;i<20;i++)
    {
   if(i%4==0)
           checkout(i);
        }      

      checkout(0xCC);
}



void ledon(void)
{
P0=0x00;
P0=0xFF;

}

void ledoff(void)
{

P0=0x00;
}




void main()
{
while(1)
{
init();
ledon();
sent();
ledoff();
};


}

#include   <stdio.h>  
#include   <string.h>  
#include   <unistd.h>  
#include   <fcntl.h>  
#include   <errno.h>  
#include   <termios.h>  
#include   <sys/time.h>
int openport(char *Dev)  
{
int fd = open( Dev, O_RDWR|O_NOCTTY|O_NDELAY );
if (-1 == fd)
{    
  perror("Can''t Open Serial Port");
  return -1;  
}
else
  return fd;

}  
  
int setport(int fd, int baud,int databits,int stopbits,int parity)
{
int baudrate;
struct   termios   newtio;  
switch(baud)
{
case 300:
  baudrate=B300;
  break;
case 600:
  baudrate=B600;
  break;
case 1200:
  baudrate=B1200;
  break;
case 2400:
  baudrate=B2400;
  break;
case 4800:
  baudrate=B4800;
  break;
case 9600:
  baudrate=B9600;
  break;
case 19200:
  baudrate=B19200;
  break;
case 38400:
  baudrate=B38400;
  break;
default :
  baudrate=B9600;  
  break;
}
tcgetattr(fd,&newtio);    
bzero(&newtio,sizeof(newtio));  
   //setting   c_cflag
newtio.c_cflag   &=~CSIZE;    
switch (databits) /*设置数据位数*/
{  
case 7:  
  newtio.c_cflag |= CS7; //7位数据位
  break;
case 8:    
  newtio.c_cflag |= CS8; //8位数据位
  break;  
default:  
  newtio.c_cflag |= CS8;
  break;    
}
switch (parity) //设置校验
{  
case 'n':
case 'N':  
  newtio.c_cflag &= ~PARENB;   /* Clear parity enable */
  newtio.c_iflag &= ~INPCK;     /* Enable parity checking */
  break;
case 'o':  
case 'O':    
  newtio.c_cflag |= (PARODD | PARENB); /* 设置为奇效验*/
  newtio.c_iflag |= INPCK;             /* Disnable parity checking */
  break;
case 'e':
case 'E':  
  newtio.c_cflag |= PARENB;     /* Enable parity */  
  newtio.c_cflag &= ~PARODD;   /* 转换为偶效验*/    
  newtio.c_iflag |= INPCK;       /* Disnable parity checking */
  break;
case 'S':
case 's':  /*as no parity*/  
     newtio.c_cflag &= ~PARENB;
  newtio.c_cflag &= ~CSTOPB;break;
default:  
  newtio.c_cflag &= ~PARENB;   /* Clear parity enable */
  newtio.c_iflag &= ~INPCK;     /* Enable parity checking */
  break;  
}
switch (stopbits)//设置停止位
{  
case 1:  
  newtio.c_cflag &= ~CSTOPB;  //1
  break;
case 2:  
  newtio.c_cflag |= CSTOPB;  //2
    break;
default:
  newtio.c_cflag &= ~CSTOPB;
  break;
}
newtio.c_cc[VTIME] = 0;  
newtio.c_cc[VMIN] = 0;
newtio.c_cflag   |=   (CLOCAL|CREAD);
newtio.c_oflag|=OPOST;
newtio.c_iflag   &=~(IXON|IXOFF|IXANY);                    
    cfsetispeed(&newtio,baudrate);  
    cfsetospeed(&newtio,baudrate);  
    tcflush(fd,   TCIFLUSH);
if (tcsetattr(fd,TCSANOW,&newtio) != 0)  
{
  perror("SetupSerial 3");
  return -1;
}
return 0;
}
int readport(int fd,char *buf,int len,int maxwaittime)//读数据，参数为串口，BUF，长度，超时时间
{
int no="0";int rc;int rcnum="len";
struct timeval tv;
fd_set readfd;
tv.tv_sec=maxwaittime/1000;    //SECOND
tv.tv_usec=maxwaittime%1000*1000;  //USECOND
FD_ZERO(&readfd);
FD_SET(fd,&readfd);
rc=select(fd+1,&readfd,NULL,NULL,&tv);
if(rc>0)
{
  while(len)
  {
   rc=read(fd,&buf[no],1);
   if(rc>0)
    no=no+1;
   len=len-1;  
  }
  if(no!=rcnum)
   return -1;      //如果收到的长度与期望长度不一样，返回-1
  return rcnum;      //收到长度与期望长度一样，返回长度
}
else
{
  return -1;
}
return -1;
}
int writeport(int fd,char *buf,int len)  //发送数据
{
write(fd,buf,len);
}
void clearport(int fd)      //如果出现数据与规约不符合，可以调用这个函数来刷新串口读写数据
{
tcflush(fd,TCIOFLUSH);
}
main()  
{  
int   fd,rc,i,ret;  
unsigned char rbuf[256];
unsigned char wbuf[256]="";
for(i=0;i<256;i++)
  wbuf[i]=i;
char *dev ="/dev/ttyS0";    //串口号 /dev/ttyS0  对应于串口1
    fd  =  openport(dev);     //打开串口
if(fd>0)
{
  ret=setport(fd,4800,8,1,'o');  //设置串口，波特率，数据位，停止位，校验
  if(ret<0)
  {
   printf("Can't Set Serial Port!\n");
   exit(0);
  }
}
else
{
  printf("Can't Open Serial Port!\n");
  exit(0);
}
while(1){
  rc=readport(fd,rbuf,5,500);   //读取5个字节，超时时间为500毫秒
  if(rc>0)
  {
   writeport(fd,wbuf,rc);
   printf("recv:%d\n",rc);
   for(i=0;i<rc;i++)
   printf("%02x ",rbuf[i]);
   printf("\n");
  }
  else
   printf("recv none\n");
}  
close(fd);  
}  

<?php

// --------------------------------------------------------------------------

// File name   : RS232_Server.php

// Description : RS232演示上位机程序

// Requirement : PHP 5.1.4 (cli) (http://www.php.net)

//

// Copyright(C), HonestQiao, 2006, All Rights Reserved.

//

// Author: HonestQiao (honestqiao@hotmail.com/QQ:5601680)

//

// 程序简介：

// 本程序与RS232_Client构成一个完整的演示系统，展示了PHP在RS232串口通讯上的应用。

// 程序之中实现了一个基础但是完整的RS232通讯协议(HQB232)，通讯协议格式如下：

// 协议内容：

//             C->S 01 //请求通讯

//             S->C 02 //响应通讯

//             C->S LEN DATA //LEN表示数据(DATA)长度 DATA表示实际数据

//             C->S 03 //结束通讯

// 说明：S表示上位机 C表示下位机

//       HQB232表示HonestQiao演示的基础(Base)RS232通讯协议，包含了协议的

//   请求和响应，数据帧的结构。

//       演示过程为通讯的请求和响应，十次数据帧的发送， 通讯的结束

//       数据帧的结构为当前的序号，microtime()，随机字符串

//

//       欢迎探讨PHP在RS232串口通讯上的应用。

// --------------------------------------------------------------------------

set_time_limit(0);
exec('mode COM1: baud=9600  data=8 stop=1 parity=n xon=on');
$fd = dio_open('COM1:', O_RDWR);
if(!$fd)
{
  die("Error when open COM1");
}
$ff = dio_stat($fd);print_r($ff);
echo "HQB232 SERVER is listenning on COM1\n";
/// read
$len = 2;
$t=0;while (($t++)<1000)
{
  $data = dio_read($fd, $len);
  if ($data) {
    if($data==chr(0).chr(1)){
      echo "S_RECV:01\n";
      echo "S_SEND:02\n";
      dio_write($fd,chr(0).chr(2));
      break;
    }
  }
}
/// read
$len = 2;
$t=0;while (($t++)<1000)
{
  $len = 2;
  $data = dio_read($fd, $len);
  if($data==chr(0).chr(3)){
    echo "S_RECV:03\n";
    break;
  }
  elseif ($data) {
    $len = intval($data);
    $data = dio_read($fd, $len);
    if($data){
      echo "S_RECV:($len)$data\n";
    }
  }
}
dio_close($fd);
?>

<?php

// --------------------------------------------------------------------------

// File name   : RS232_Client.php

// Description : RS232演示下位机程序

// Requirement : PHP 5.1.4 (cli) (http://www.php.net)

//

// Copyright(C), HonestQiao, 2006, All Rights Reserved.

//

// Author: HonestQiao (honestqiao@hotmail.com/QQ:5601680)

//

// 程序简介：

// 本程序与RS232_Server构成一个完整的演示系统，展示了PHP在RS232串口通讯上的应用。

// 程序之中实现了一个基础但是完整的RS232通讯协议(HQB232)，通讯协议格式如下：

// 协议内容：

//             C->S 01 //请求通讯

//             S->C 02 //响应通讯

//             C->S LEN DATA //LEN表示数据(DATA)长度 DATA表示实际数据

//             C->S 03 //结束通讯

// 说明：S表示上位机 C表示下位机

//       HQB232表示HonestQiao演示的基础(Base)RS232通讯协议，包含了协议的

//   请求和响应，数据帧的结构。

//       演示过程为通讯的请求和响应，十次数据帧的发送， 通讯的结束

//       数据帧的结构为当前的序号，microtime()，随机字符串

//

//       欢迎探讨PHP在RS232串口通讯上的应用。

// --------------------------------------------------------------------------

set_time_limit(0);
//exec('mode COM1: baud=9600 data=8 stop=1 parity=n xon=on');
exec('mode COM1: baud=9600  data=8 stop=1 parity=n xon=on');
$fd = dio_open('COM1:', O_RDWR);
if(!$fd)
{
  die("Error when open COM1");
}
$ff = dio_stat($fd);
echo "HQB232 CLIENT is start on COM1\n";
dio_write($fd,chr(0).chr(1));echo "C_SEND:01\n";
$len = 2;
$t=0;while(($t++)<1000)
{
  $data = dio_read($fd, $len);
  if($data==chr(0).chr(2)){
    echo "C_RECV:02\n";
    break;
  }
}
$len = 2;
$t=0;while(($t++)<10)
{
  $sdata = sprintf("%03d",$t) . "=" . microtime() . " (" . randomkeys(rand(0,35)) . ")";
  $slen = strlen($sdata);
  $stxlen = sprintf("%02d",$slen);
  dio_write($fd,"$stxlen");
  dio_write($fd,"$sdata");
    echo "C_SEND:($stxlen)$sdata\n";
  //sleep(1);
}
dio_write($fd,chr(0).chr(3));echo "C_SEND:03\n";
dio_close($fd);
function randomkeys($length)
{
   $pattern = "1234567890abcdefghijklmnopqrstuvwxyz";
   for($i=0;$i<$length;$i++)
   {
     $key .= $pattern{rand(0,35)};
   }
   return $key;
}
?>

UPDATE:
UPDATE A SET ApproverID=NULL,ApproveDate=NULL,ApproveResult=100,CheckerID=null,CheckDate=null, IsCheck=0
FROM [SH_MaterialApplyBuyBill] A
LEFT JOIN [SH_MaterialApplyBuyBillDetail] B ON A.ID=B.[MaterialApplyBuyBillID]
WHERE A.id=125 AND @InDetailCount=0
DELETE:
DELETE A FROM [SH_ClosingBalance] A LEFT JOIN [SH_StoreHouse] B ON A.StoreHouseID=B.ID
WHERE B.departmentID='1000'