«

123123

Qihan 发布于 阅读：514

.gqh-page-container {
    width: 100%;
    background-color: rgb(50,187,180);
    text-align: center;
    padding: 5px 0;
    position: relative;
  }

  .gqh-page-button {
    padding: 5px 20px;
    border: 1px solid #d9d9d9;
    border-color: #d9d9d9;
    color: #333;
    background: #fff;
    cursor: pointer;
    border-radius: 5px;
  }

  .gqh-prev-button, .gqh-next-button {
    position: absolute;
    top: 50%;
    transform: translateY(-50%);
  }

  .gqh-prev-button {
    left: 10px;
  }

  .gqh-next-button {
    right: 10px;
  }

  .gqh-page-info {
    display: inline-block;
    vertical-align: middle;
    color: white;
  }

  .gqh-page-input {
    padding: 5px;
    margin: 0 5px;
    text-align: center;
  }

  .gqh-go-button {
    padding: 3px 15px 5px 15px;
    border-radius: 5px;
     border: 1px solid #d9d9d9;
    border-color: #d9d9d9;
    color: #333;
    background: #fff;
    cursor: pointer;
  }

 

https://e-cloudstore.com/doc.html?appId=ddb03e0fa89048bbab26cba6b2f02b75

uf_driverConfig

 

CREATE TABLE 新表名 AS SELECT * FROM 旧表名;

 

/api/Cardevelop/getDriverCount?data=2024-12-22

 

totalCount 


com.gqh.sph.action.InsertMeetingAgenda

<serverName>服务名（参照各服务的方法名称）</serverName>

<format>XML/HL7V3</format> 

<callOperator>调用操作者,可为空</callOperator>

<certificate>凭证号私发</certificate>

 
SOAPAction：
getStaffDict
 

<?xml version="1.0" encoding="utf-8"?>

<root>

    <!--机构代码-->

    <orgCode>机构代码</orgCode>

    <!--院区代码-->

    <districtCode>院区代码</districtCode>

    <!--科室代码-->

    <deptCode>科室代码</deptCode>

    <!--员工姓名-->

    <staffName>员工姓名</staffName>

    <!--员工代码-->

    <staffCode>员工代码</staffCode>

    <!--员工工牌号-->

    <employeNo>员工工牌号</employeNo>

    <!--工作类别编码-->

    <workClassCode>工作类别编码</workClassCode>

    <!--每页行数(不超过1200)，必填-->

    <size>每页行数(不超过1200)必填</size>

    <!--页码，必填-->

    <page>页码必填</page>

</root>
 
 
 
 
 
SELECT person_name
FROM person_schedule
WHERE TO_CHAR(SYSDATE, 'HH24:MI') >= TO_CHAR(start_time, 'HH24:MI')
AND TO_CHAR(SYSDATE, 'HH24:MI') <= TO_CHAR(end_time, 'HH24:MI');
查询类接口调用地址：http://192.168.11.200:8689/Select-Service?wsdl 
凭证号：eC55vf8yE3mvnBWwBbw7rE/g7h+F8GtB
 
SELECT person
FROM uf_driverConfig
WHERE CAST(CURRENT_TIMESTAMP AS TIME) >= startTime
  AND CAST(CURRENT_TIMESTAMP AS TIME) < endTime;
 
SELECT person 
FROM uf_driverConfig 
WHERE TO_CHAR(SYSDATE, 'HH24:MI') >= TO_CHAR(startTime, 'HH24:MI') 
AND TO_CHAR(SYSDATE, 'HH24:MI') <= TO_CHAR(endTime, 'HH24:MI') AND isActive=0
AND person NOT IN(SELECT driver FROM uf_driverActivityLog WHERE isEnded IS NULL OR isEnded = 1)

推荐阅读：