web
/
local_archive


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
							<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>测试sqlite</title>
</head>
<body>
<script type="text/javascript" src="../utijs/vue.js"></script>
<script type="text/javascript">
    var db = openDatabase('test1341', '', '测试', 2 * 1024 * 1024);
    var msg;
    var parentId='1637727829841936384';
    var projectId='1578599210897772545';
    var list = [];
    var archiveId=1640281405390848000;
    db.transaction(function (tx) {

        //单击查看卷内文件目录列表
        tx.executeSql('select file_number,file_name,pdf_file_url,file_time from u_archive_file where archive_id = ?',
            [archiveId], function (tx, results) {
                var len = results.rows.length, i;
                console.log(results.rows);
                for (i = 0; i < len; i++) {
                    msg = "<p><b>" + results.rows.item(i).file_name +"--"+results.rows.item(i).pdf_file_url + "</b></p>";
                    document.querySelector('#status').innerHTML += msg;
                }
        }, null);
    });
    // db.transaction(function (tx) {
    //     var like;
    //     if (likeName == null){
    //         like = '%';
    //     }else {
    //         like = '%'+likeName+'%';
    //     }
    //     tx.executeSql('SELECT *,(strftime("%Y/%m/%d",u.start_date)||"~"||strftime("%Y/%m/%d",u.end_date)) as startendtime FROM u_archives_auto u WHERE node_id in (select id FROM m_archive_tree_contract m1 WHERE  ancestors like ? AND project_id = ?) and u.name like ? LIMIT ? OFFSET ?',
    //         ['%'+parentId+'%',projectId,like,pageSize,currentPage*pageSize], function (tx, results) {
    //         var len = results.rows.length, i;
    //         msg = "<p>查询记录条数: " + len + "</p>";
    //         document.querySelector('#status').innerHTML +=  msg;
    //         for (i = 0; i < len; i++){
    //             data = results.rows;
    //             msg = "<p><b>" + results.rows.item(i).id +data[i].file_number + "</b></p>";
    //             document.querySelector('#status').innerHTML +=  msg;
    //         }
    //             console.log(data);
    //             console.log(1);
    //             console.log(likeName);
    //             console.log(likeName+'');
    //     }, null);
    //     console.log(like);
    // });
</script>
<div id="status" name="status">状态信息</div>
</body>
</html>