frompot_libs.mysql_util.mysql_utilimportMysqlUtilasyncdefsid_to_order_dao(sid):sql="SELECT p.pid FROM `monitor` m LEFT JOIN point p " \"on p.mtid=m.mtid where m.sid=%s and m.demolished=0"asyncwithMysqlUtil()asconn:data=awaitconn.fetchall(sql,args=(sid,))returndataasyncdefselect_cids_by_prod_id(pro_id):sql="select cid from company where product=%s"asyncwithMysqlUtil()asconn:data=awaitconn.fetchall(sql,args=(pro_id,))returndataasyncdefselect_sid_by_pid(pid):sql="SELECT p.name, m.sid,p.pid FROM `monitor` m LEFT JOIN point p " \"on p.mtid=m.mtid where p.pid=%s and m.demolished=0"asyncwithMysqlUtil()asconn:data=awaitconn.fetchone(sql,args=(pid,))returndataasyncdefselect_sid_by_pids(cids):sql="SELECT p.name, m.sid,p.pid FROM `monitor` m LEFT JOIN point p " \"on p.mtid=m.mtid where p.pid in %s and m.demolished=0"asyncwithMysqlUtil()asconn:data=awaitconn.fetchall(sql,args=(cids,))returndataasyncdefselect_cname_by_cids(cids):sql=f"select shortname,product,cid from company where cid in %s"asyncwithMysqlUtil()asconn:data=awaitconn.fetchall(sql,args=(cids,))returndata