tryer 发布的文章

看到长长的信用卡帐单，看着让人蛋疼的还款数字，总是不免怀疑是不是计算不正确，哪有这么多钱，我有这么能花嘛，核算一下这么多数字总不能一条条的输入计算器吧，身为半吊子程序员的我，采用如下方法进行快速核算：

一、获取帐单数据
复制帐单表格，去掉其它的列，只保留数字列，去掉退款项（对应有存入的项目）

  1. 用开发者工具选取表格代码
  2. 将代码复制到在线HTML处理工具中https://html-cleaner.com/，删除相应的列与行，只保留数字列
  3. 将数字复制到文本文件中

二、计算
读取文本文件，逐行累加数字，输出结果，PYTHON几行搞定


total = 0
for line in open("xyk.txt"):
    total += float(line.replace(',',''))

print total

一、vue的引入

header 会被 api.fixStatusBar 重置 所以不要有设置高度 也会被重置

window frame 的配合使用

高效开发方式
https://github.com/grapewheel/avvw
Apicloud + Vue2 + Vant（有赞前端）+ Webpack4打包，是一个采用Vue数据绑定特性和Apicloud手机操控能力相结合的APP开发框架，此框架并非采用Vue的SPA单页面应用方式，而是遵从Apicloud的多页面原生渲染效率方式，Vue+Webpack只是为了提供更佳的ES2015语法、模块分割和数据绑定代码体验，弥补Apicloud本身无法应用在庞大工程协作的缺点。

信息共享、传递机制
api.execScript 与 api.sendEvent param

源码研究
实际项目APK源码
官方示例源码

加密的破解

模块的使用、自定义模块的开发

采用原生javascript项目实现 播放器等，现有模块更方便，但灵活性不高
尽量不使用jquery bootstrap，采用轻量级的原生JS库 多收集

api $api区别

app判断是否登录

前端框架，UI框架
要优先选择使用Mobile First的框架 、 模版
https://github.com/search?o=desc&q=Mobile+First&s=stars&type=Repositories
SUI Mobile
WeTouch
FrozenUI
Amaze
MUI
WeUI
AUI
Zui
purecss
HUI3.0 更轻、更快、更漂亮的UI框
打造最好的移动端UI框架，适用于基于H5+的移动app开发并完美兼容移动端web开发！
Spectre.css
Bulma
Materialize
https://www.mdui.org

# -*- coding:utf-8*-
import sys
reload(sys)
sys.setdefaultencoding('utf-8')


import os
import os.path
from pyPdf import PdfFileReader,PdfFileWriter
import time
time1 = time.time()


# 使用os模块walk函数，搜索出某目录下的全部pdf文件
######################获取同一个文件夹下的所有PDF文件名#######################

def getFileName(filepath):
    file_list = []
    for root,dirs,files in os.walk(filepath):
        for filespath in files:
            #print(filespath)
            if filespath[-3:] == 'pdf':
                file_list.append(os.path.join(root, filespath))

    return file_list



##########################合并同一个文件夹下所有PDF文件########################

def MergePDF(filepath,outfile):
    output=PdfFileWriter()
    outputPages=0
    pdf_fileName=getFileName(filepath)
    for each in pdf_fileName:
        print each
        # 读取源pdf文件
        input = PdfFileReader(file(each, "rb"))

        # 如果pdf文件已经加密，必须首先解密才能使用pyPdf
        if input.isEncrypted == True:
            input.decrypt("map")

        # 获得源pdf文件中页面总数
        pageCount = input.getNumPages()
        outputPages += pageCount
        print pageCount

        # 分别将page添加到输出output中
        for iPage in range(0, pageCount):
            output.addPage(input.getPage(iPage))


    print "All Pages Number:"+str(outputPages)
    # 最后写pdf文件
    outputStream=file('e:\\pdf\\' + outfile, "wb")
    output.write(outputStream)
    outputStream.close()
    print "finished"


def rename(path):
    #path = "E:\\Website\\test\\".decode('utf-8').encode('GB2312')
    filelist = os.listdir(path)
    for files in filelist:
        olddir = os.path.join(path,files)
        if os.path.isdir(olddir):
            print olddir.decode('GB2312').encode('utf-8')
            MergePDF(olddir, 'xlzs' + files + '.pdf')


if __name__ == '__main__':
    file_dir = 'E:\Website\中心医院\杏林之声pdf201501-201904'.decode('utf-8').encode('GB2312')
    out = u"第一周.pdf"
    rename(file_dir)
    #MergePDF(file_dir,out)
    time2 = time.time()
    print u'总共耗时：' + str(time2 - time1) + 's'

注意事项：路径的正确写法、证书文件的指定

#
# This is the Apache server configuration file providing SSL support.
# It contains the configuration directives to instruct the server how to
# serve pages over an https connection. For detailed information about these 
# directives see <URL:http://httpd.apache.org/docs/trunk/mod/mod_ssl.html>
# 
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure
# consult the online docs. You have been warned.  
#

#
# Pseudo Random Number Generator (PRNG):
# Configure one or more sources to seed the PRNG of the SSL library.
# The seed data should be of good random quality.
# WARNING! On some platforms /dev/random blocks if not enough entropy
# is available. This means you then cannot use the /dev/random device
# because it would lead to very long connection times (as long as
# it requires to make more entropy available). But usually those
# platforms additionally provide a /dev/urandom device which doesn't
# block. So, if available, use this one instead. Read the mod_ssl User
# Manual for more details.
#
#SSLRandomSeed startup file:/dev/random  512
#SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random  512
#SSLRandomSeed connect file:/dev/urandom 512


#
# When we also provide SSL we have to listen to the 
# standard HTTP port (see above) and to the HTTPS port
#
# Note: Configurations that use IPv6 but not IPv4-mapped addresses need two
#       Listen directives: "Listen [::]:443" and "Listen 0.0.0.0:443"
#
Listen 443

##
##  SSL Global Context
##
##  All SSL configuration in this context applies both to
##  the main server and all SSL-enabled virtual hosts.
##

#   Pass Phrase Dialog:
#   Configure the pass phrase gathering process.
#   The filtering dialog program (`builtin' is a internal
#   terminal dialog) has to provide the pass phrase on stdout.
SSLPassPhraseDialog  builtin

#   Inter-Process Session Cache:
#   Configure the SSL Session Cache: First the mechanism 
#   to use and second the expiring timeout (in seconds).
#SSLSessionCache         "dbm:E:/phpStudy2018/PHPTutorial/Apache/logs/ssl_scache"
SSLSessionCache        "shmcb:E:/phpStudy2018/PHPTutorial/Apache/logs/ssl_scache(512000)"
SSLSessionCacheTimeout  300

##
## SSL Virtual Host Context
##
<VirtualHost weixin.linsen18.com:443>

    DocumentRoot "E:/phpStudy/WWW/newshop"

    ServerName  weixin.linsen18.com:443

    ServerAdmin 75303307@qq.com

    DirectoryIndex index.html index.htm index.php

    ErrorLog E:/phpStudy2018/PHPTutorial/Apache/logs/example_error.log

   

    SSLEngine On

    SSLCertificateFile "E:/phpStudy2018/PHPTutorial/Apache/conf/ssl/2307291_weixin.linsen18.com_public.crt"

    SSLCertificateKeyFile "E:/phpStudy2018/PHPTutorial/Apache/conf/ssl/2307291_weixin.linsen18.com.key"

    SSLCertificateChainFile "E:/phpStudy2018/PHPTutorial/Apache/conf/ssl/2307291_weixin.linsen18.com_chain.crt"

<FilesMatch "\.(shtml|phtml|php)$">

    SSLOptions +StdEnvVars

</FilesMatch>

    #BrowserMatch "MSIE [2-5]" \

    #nokeepalive ssl-unclean-shutdown \

    #downgrade-1.0 force-response-1.0



</VirtualHost>                               



# -*- coding:utf-8 -*-

import xlrd
import xlsxwriter
import os
import sys
#读取目录 遍历文件 读取每一个文件的第一个sheet 写入目标文件 放在一个sheet里



def open_xls(file):
    try:
        fh = xlrd.open_workbook(file)
        return fh
    except Exception as e:
        print("打开文件错误：" + e)


# 根据excel名以及第几个标签信息就可以得到具体标签的内容
def get_file_value(filename, sheetnum):
    rvalue = []
    fh = open_xls(filename)
    sheet = fh.sheets()[sheetnum]
    row_num = sheet.nrows
    for rownum in range(0, row_num):
        rvalue.append(sheet.row_values(rownum))
    return rvalue

end_xls = "L:\\excel\\final_excel.xlsx"

path = "L:\\excel\\".decode('utf-8').encode('GB2312')
filelist = os.listdir(path)

# 定义一个目标excel
endxls = xlsxwriter.Workbook(end_xls)
end_xls_sheet = endxls.add_worksheet('aa')
num = 1
for files in filelist:
    fh = open_xls(path + files)
    sheet = fh.sheets()[0]
    row_num = sheet.nrows
    for rownum in range(1, row_num):
        #print sheet.row_values(rownum)
        end_xls_sheet.write_row('A' + str(num), sheet.row_values(rownum))
        num += 1
endxls.close()
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7