/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

fao.utils = {
sqldsl : function(table,phrase,condi){
          var sqlstmts = ["",""];
          if(table == "activities"){
            var result = phrase.match(/^(\w{32}):/);
            if(result){ 
              sqlstmt = "select a.* from activities as a join staffds as sd on a.id = sd.activity_id where sd.staff_id = '" + result[1]  + "' and a.sync_state != 'deleted' order by a." + condi.sort + " " + condi.dir + " limit " + condi.results + " offset " + condi.startIndex;
              sqlstmt_count = "select count(*) from activities as a join staffds as sd on a.id = sd.activity_id where sd.staff_id = '" + result[1]  + "' and a.sync_state != 'deleted'";
              return [sqlstmt,sqlstmt_count];
            }
            else{
             sqlstmt = "select * from activities where (dguojia like  '%" + phrase  + "%'  or dgjpy like  '%" + phrase + "%'  or dgjspy like  '%" + phrase + "%' ) and sync_state != 'deleted' order by " + condi.sort + " " + condi.dir + " limit " + condi.results + " offset " + condi.startIndex;
             sqlstmt_count = "select count(*) from activities where (dguojia like  '%" + phrase  + "%'  or dgjpy like  '%" + phrase + "%'  or dgjspy like  '%" + phrase + "%' ) and sync_state != 'deleted'";
              return [sqlstmt,sqlstmt_count];
             }
          }
          else if(table == "staffs"){
             sqlstmt = "select * from staffs where (name like '%" + phrase + "%' or pyname like '%" + phrase + "%' or spyname like '%" + phrase + "%') and sync_state != 'deleted' order by " + condi.sort + " " + condi.dir + " limit " + condi.results + " offset " + condi.startIndex;
             sqlstmt_count = "select count(*) from staffs where (name like '%" + phrase + "%' or pyname like '%" + phrase + "%' or spyname like '%" + phrase + "%') and sync_state != 'deleted'";
              return [sqlstmt,sqlstmt_count];
          }
          else{

          }
          return sqlstmts;
         },
      datestr2milliseconds : function(date_str){
//        alert(YAHOO.lang.isString(date_str));
        if(!date_str){
          return  32758707661001;
        }
        var ymd = /(\d{4})[^\d](\d{1,2})[^\d](\d{1,2})/;
        var result = date_str.match(ymd);
        if(!result){
          result = date_str.match(/(\d{4})(\d{2})(\d{2})/);
        }
        if(result){
          var y = result[1];
          y = y.replace(/^0+/,"");
          var m = result[2];
          m = m.replace(/^0+/,"");
          var d = result[3];
          d = d.replace(/^0+/,"");
            var date = new Date(parseInt(y),parseInt(m) - 1,parseInt(d),1,1,1,1);
            return date.getTime();
        } else{
          return 32758707661001;
        }
      },
      milliseconds2date : function(milliseconds){
        var ms = parseInt(milliseconds);
        if(isNaN(ms)){
          ms =  32758707661001;
        }
        var aDate = new Date(ms);
        return aDate;
      },
      milliseconds2datestr : function(milliseconds){
        var ms = parseInt(milliseconds);
        if(isNaN(ms)){
          ms =  32758707661001;
        }
        var oDate = new Date(ms);
       if(oDate.getFullYear() == 3008){
         return "";
       }else{
         return oDate.getFullYear() + "-" + (oDate.getMonth()+1) + "-" + oDate.getDate();
       }
     },
      milliseconds2age : function(nDatetimes){
          var date = new Date(nDatetimes);
          var thisyear = new Date();
          if(date.getFullYear() == 3008){
            return "";
          }else{
            return(thisyear.getFullYear() - date.getFullYear());
          }
      },
      date2str : function(oDate){
                   if(oDate.getFullYear() == 3008){
                     return "";
                   }else{
                     return oDate.getFullYear() + "-" + (oDate.getMonth()+1) + "-" + oDate.getDate();
                   }
                 },

      formatDate : function(elCell, oRecord, oColumn, oData){
          var mydate = oData;
            try{
              var y = mydate.getFullYear();
              var m = mydate.getMonth()+1;
              var d = mydate.getDate();
              m = m < 10 ? "0"+ m : m;
              d = d < 10 ? "0"+ d : d;
              if(y==3008){
                elCell.innerHTML = ""; 
              }else{
                elCell.innerHTML = y + "-" + m + "-" + d;
              }
            }catch(e){
              elCell.innerHTML = ""; 
            }
      },
      chDate : function(oDate){
          var date =oDate;
          var y = date.getFullYear();
          var m = date.getMonth()+1;
          var d = date.getDate();
          m = m < 10 ? "0"+ m : m;
          d = d < 10 ? "0"+ d : d;
          return(y + "年" + m + "月" + d + "日");
      }
    };

    fao.utils.ch2py = new function(){
      this.pya = [];  
      this.pyb = [];
      this.pyc = [];
      this.pyd = [];

//      this.find_pinyin111= function(c){
//        for(var i=0;i<pinyin_ary.length;i++){
//          var py = pinyin_ary[i].split(",");
//          if(py[0] == c){
//            return py[1];
//          }else{
//            false;
//          }
//        }
//      };

      this.find_pinyin_mem = function(c){
        if(c.match(/^\w{1}$/)){
            return c;
        };
        for(var i=0;i<pinyin_ary.length;i++){
          var py = pinyin_ary[i].split(",");
          if(py[0] == c){
            return py[1];
          }else{
            false;
          }
        }
      };

     this.find_pinyin_db = function(c){
       if(c.match(/^\w{1}$/)){
           return c;
       };
       var rs = fao.variables.db.execute("select pys from pys where hanzi=?",[c]);
       if(rs.isValidRow()){
         return rs.field(0);
       }else{
         return false;
       }
       if(rs)rs.close();
     }; 

      this.find_pystr = function(str){
        try{
          this.pya = [""];
          this.pyc = [""];
          for(var i=0;i<str.length;i++){
            var py = fao.variables.pinyindb ? this.find_pinyin_db(str.charAt(i)) : this.find_pinyin_mem(str.charAt(i));
            if(py){
              var pys = py.split(/\s/);
              for(var j=0;j<pys.length;j++){
                for(var k=0;k<this.pya.length;k++){
                  this.pyb.push(this.pya[k] + pys[j]);
                  this.pyd.push(this.pyc[k] + pys[j].charAt(0));
                }
              }
              this.pya = this.pyb;
              this.pyc = this.pyd;
              this.pyb = [];
              this.pyd = [];
            }
          }
          return [this.pya,this.pyc];
        }catch(e){
          alert("from fao.utils.ch2py:" + e.message);
        }
      };
    };