Quatek

Versions

Installed Packages

Installation paths relative to:

/home/twspi/.local/share/virtualenvs/new_quatek-YcMXAgLI/lib/python3.6/site-packages

Package	Version	Installed Path
alembic	1.0.5
APScheduler	3.6.0
arrow	0.12.1
atomicwrites	1.2.1
attrs	18.2.0
bcrypt	3.1.5
beautifulsoup4	4.6.3
binaryornot	0.4.4
blinker	1.4
certifi	2018.10.15
cffi	1.11.5
chardet	3.0.4
Click	7.0
colorama	0.4.1
cookiecutter	1.6.0
dominate	2.3.5
environs	4.0.0
et-xmlfile	1.0.1
factory-boy	2.11.1
Faker	1.0.1
flake8	3.5.0
flake8-blind-except	0.1.1
flake8-debugger	3.1.0
flake8-docstrings	1.3.0
flake8-isort	2.5
flake8-polyfill	1.0.2
flake8-quotes	1.0.0
Flask	1.0.2
Flask-APScheduler	1.11.0
Flask-Bcrypt	0.7.1
Flask-Bootstrap	3.3.7.1
Flask-Caching	1.4.0
Flask-Cors	3.0.7
Flask-DebugToolbar	0.10.1
Flask-Excel	0.0.7
Flask-Login	0.4.1
Flask-Migrate	2.3.1
Flask-Script	2.0.6
Flask-SQLAlchemy	2.3.2
Flask-Webpack	0.1.0
Flask-WTF	0.14.2
future	0.17.1
gunicorn	19.9.0
idna	2.8
isort	4.3.4
itsdangerous	1.1.0
jdcal	1.4
Jinja2	2.10
jinja2-time	0.2.0
lml	0.0.9
Mako	1.0.7
MarkupSafe	1.1.0
marshmallow	2.16.3
mccabe	0.6.1
more-itertools	4.3.0
numpy	1.16.4
openpyxl	2.5.12
pep8-naming	0.7.0
Pillow	6.0.0
pip	20.2.2
pluggy	0.8.0
poyo	0.4.2
psycopg2	2.7.5
py	1.7.0
pycodestyle	2.3.1
pycparser	2.19
pydocstyle	3.0.0
pyexcel	0.5.15
pyexcel-io	0.5.20
pyexcel-webio	0.1.4
pyexcel-xls	0.5.8
pyexcel-xlsx	0.5.7
pyflakes	1.6.0
pymssql	2.1.4
PyMySQL	0.9.3
pytest	3.7.4
python-dateutil	2.7.5
python-dotenv	0.10.1
python-editor	1.0.3
pytz	2019.1
requests	2.21.0
sense-hat	2.2.0
setuptools	49.6.0
six	1.11.0
snowballstemmer	1.2.1
SQLAlchemy	1.2.14
testfixtures	6.4.0
text-unidecode	1.2
texttable	1.6.2
tzlocal	1.5.1
urllib3	1.24.1
visitor	0.1.3
waitress	1.1.0
WebOb	1.8.4
WebTest	2.0.30
Werkzeug	0.14.1
wheel	0.35.1
whichcraft	0.5.2
wincertstore	0.2
WTForms	2.2.1
xlrd	1.1.0
xlwt	1.3.0

Resource Usage

Resource	Value
User CPU time	3.246 msec
System CPU time	0.000 msec
Total CPU time	3.246 msec
Elapsed time	3.247 msec
Context switches	0 voluntary, 0 involuntary

HTTP Headers

Key	Value
HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_ACCEPT_ENCODING	br,gzip
HTTP_ACCEPT_LANGUAGE	en-US,en;q=0.5
HTTP_CONNECTION	Keep-Alive
HTTP_HOST	59.120.44.202:4813
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
QUERY_STRING
REMOTE_ADDR	3.236.124.56
REQUEST_METHOD	GET
SCRIPT_NAME
SERVER_NAME	0.0.0.0
SERVER_PORT	4813
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	gunicorn/19.9.0

Request Vars

View information

View Function	args	kwargs
myflaskapp.views.public.home	[]	None

COOKIES Variables

No COOKIE data

SESSION Variables

Variable	Value
'csrf_token'	'9d16537b3ff239e006160a3cc0bf79fd66206b38'

GET Variables

Variable	Value

POST Variables

Variable	Value

Config

Key	Value
APPLICATION_ROOT	`'/'`
BCRYPT_LOG_ROUNDS	`13`
BOOTSTRAP_CDN_FORCE_SSL	`False`
BOOTSTRAP_LOCAL_SUBDOMAIN	`None`
BOOTSTRAP_QUERYSTRING_REVVING	`True`
BOOTSTRAP_SERVE_LOCAL	`False`
BOOTSTRAP_USE_MINIFIED	`True`
CACHE_TYPE	`'simple'`
DEBUG	`True`
DEBUG_TB_ENABLED	`True`
DEBUG_TB_HOSTS	`()`
DEBUG_TB_INTERCEPT_REDIRECTS	`False`
DEBUG_TB_PANELS	('flask_debugtoolbar.panels.versions.VersionDebugPanel', 'flask_debugtoolbar.panels.timer.TimerDebugPanel', 'flask_debugtoolbar.panels.headers.HeaderDebugPanel', 'flask_debugtoolbar.panels.request_vars.RequestVarsDebugPanel', 'flask_debugtoolbar.panels.config_vars.ConfigVarsDebugPanel', 'flask_debugtoolbar.panels.template.TemplateDebugPanel', 'flask_debugtoolbar.panels.sqlalchemy.SQLAlchemyDebugPanel', 'flask_debugtoolbar.panels.logger.LoggingPanel', 'flask_debugtoolbar.panels.route_list.RouteListDebugPanel', 'flask_debugtoolbar.panels.profiler.ProfilerDebugPanel')
ENV	`'development'`
EXPLAIN_TEMPLATE_LOADING	`False`
JOBS	`[{'id': 'retrieval_tr', 'func': 'myflaskapp.services.SendEmailServices:RetrievalTR', 'args': (), 'timezone': 'Asia/Shanghai', 'trigger': 'interval', 'seconds': 60}, {'id': 'test', 'func': 'myflaskapp.services.ForecastLog:ForecastLog', 'args': (), 'timezone': 'Asia/Shanghai', 'trigger': 'cron', 'misfire_grace_time': 3600, 'day': 5, 'hour': 9, 'minute': 10}]`
JSON_AS_ASCII	`True`
JSON_SORT_KEYS	`True`
JSONIFY_MIMETYPE	`'application/json'`
JSONIFY_PRETTYPRINT_REGULAR	`False`
MAX_CONTENT_LENGTH	`None`
MAX_COOKIE_SIZE	`4093`
PERMANENT_SESSION_LIFETIME	`datetime.timedelta(31)`
PREFERRED_URL_SCHEME	`'http'`
PRESERVE_CONTEXT_ON_EXCEPTION	`None`
PROPAGATE_EXCEPTIONS	`None`
SECRET_KEY	`'not-so-secret'`
SEND_FILE_MAX_AGE_DEFAULT	`datetime.timedelta(0, 43200)`
SERVER_NAME	`None`
SESSION_COOKIE_DOMAIN	`False`
SESSION_COOKIE_HTTPONLY	`True`
SESSION_COOKIE_NAME	`'session'`
SESSION_COOKIE_PATH	`None`
SESSION_COOKIE_SAMESITE	`None`
SESSION_COOKIE_SECURE	`False`
SESSION_REFRESH_EACH_REQUEST	`True`
SQLALCHEMY_BINDS	`None`
SQLALCHEMY_COMMIT_ON_TEARDOWN	`False`
SQLALCHEMY_DATABASE_URI	`'mysql+pymysql://root:quatek_#2@$@127.0.0.1:3306/quatek_new'`
SQLALCHEMY_ECHO	`False`
SQLALCHEMY_MAX_OVERFLOW	`None`
SQLALCHEMY_NATIVE_UNICODE	`None`
SQLALCHEMY_POOL_RECYCLE	`None`
SQLALCHEMY_POOL_SIZE	`None`
SQLALCHEMY_POOL_TIMEOUT	`None`
SQLALCHEMY_RECORD_QUERIES	`None`
SQLALCHEMY_TRACK_MODIFICATIONS	`False`
TEMPLATES_AUTO_RELOAD	`None`
TESTING	`False`
TRAP_BAD_REQUEST_ERRORS	`None`
TRAP_HTTP_EXCEPTIONS	`False`
USE_X_SENDFILE	`False`
WEBPACK_MANIFEST_PATH	`'webpack/manifest.json'`
WTF_CSRF_CHECK_DEFAULT	`True`
WTF_CSRF_ENABLED	`True`
WTF_CSRF_FIELD_NAME	`'csrf_token'`
WTF_CSRF_HEADERS	`['X-CSRFToken', 'X-CSRF-Token']`
WTF_CSRF_METHODS	`{'DELETE', 'POST', 'PATCH', 'PUT'}`
WTF_CSRF_SSL_STRICT	`True`
WTF_CSRF_TIME_LIMIT	`3600`

Templates

public/home.html

Variable	Value
csrf_token	<function generate_csrf at 0x7f09344fec80>
current_user	<flask_login.mixins.AnonymousUserMixin object at 0x7f0931ec1a58>
form	<myflaskapp.forms.login_forms.LoginForm object at 0x7f09330db908>
g	<flask.g of 'myflaskapp'>
request	<ExcelRequest 'http://59.120.44.202:4813/' [GET]>
session	<SecureCookieSession {'csrf_token': '9d16537b3ff239e006160a3cc0bf79fd66206b38'}>

Log Messages

No messages logged.

Route List

URL route	Endpoint name	HTTP methods	Is alias	Redirect to
/	public.home	GET, HEAD, OPTIONS, POST	False	None
/_debug_toolbar/static/<path:filename>	_debug_toolbar.static	GET, HEAD, OPTIONS	False	None
/_debug_toolbar/views/sqlalchemy/sql_explain	debugtoolbar.sql_select	GET, HEAD, OPTIONS, POST	False	None
/_debug_toolbar/views/sqlalchemy/sql_select	debugtoolbar.sql_select	GET, HEAD, OPTIONS, POST	False	None
/_debug_toolbar/views/template/<key>	debugtoolbar.template_editor	GET, HEAD, OPTIONS	False	None
/_debug_toolbar/views/template/<key>	debugtoolbar.template_preview	OPTIONS, POST	False	None
/_debug_toolbar/views/template/<key>/save	debugtoolbar.save_template	OPTIONS, POST	False	None
/about/	public.about	GET, HEAD, OPTIONS	False	None
/adj/	adj.index	GET, HEAD, OPTIONS	False	None
/adj/adj_computation_process/<string:adj_type>/<int:year_id>/<int:employee_id>	adj.adj_computation_process	GET, HEAD, OPTIONS	False	None
/adj/adj_info/<int:id_>	adj.adj_info	GET, HEAD, OPTIONS	False	None
/adj/adj_list	adj.adj_list	GET, HEAD, OPTIONS	False	None
/adj/adj_relationship/<int:id_>	adj.adj_relationship	GET, HEAD, OPTIONS	False	None
/adj/adj_year_create	adj.adj_year_create	GET, HEAD, OPTIONS, POST	False	None
/adj/adj_year_index	adj.adj_year_index	GET, HEAD, OPTIONS	False	None
/adj/adj_year_list	adj.adj_year_list	GET, HEAD, OPTIONS	False	None
/adj/relationship_update/<int:year_id>/<string:flg>/<int:adj_id>	adj.relationship_update	GET, HEAD, OPTIONS	False	None
/adj/static/<path:filename>	adj.static	GET, HEAD, OPTIONS	False	None
/adj/upload	adj.upload	GET, HEAD, OPTIONS, POST	False	None
/adj/year_employee_count/<int:adj_year_id>	adj.year_employee_count	GET, HEAD, OPTIONS	False	None
/analysis/	analysis.index	GET, HEAD, OPTIONS	False	None
/analysis/adj/office/<int:spi_file_id>/<string:office>	analysis.adj_office	GET, HEAD, OPTIONS	False	None
/analysis/static/<path:filename>	analysis.static	GET, HEAD, OPTIONS	False	None
/api/adj/adj_computation_process/<int:year_id>/<employee_id>	api_adj.adj_computation_process	GET, HEAD, OPTIONS	False	None
/api/adj/adj_info/<int:id_>	api_adj.adj_info	GET, HEAD, OPTIONS	False	None
/api/adj/adj_list	api_adj.api_adj_list	GET, HEAD, OPTIONS	False	None
/api/adj/adj_relationship/<int:id_>/<int:is_use>	api_adj.adj_relationship	GET, HEAD, OPTIONS	False	None
/api/adj/adj_year_list	api_adj.adj_year_list	GET, HEAD, OPTIONS	False	None
/api/adj/delete/<string:_type>/<int:_id>	api_adj.adj_delete	DELETE, OPTIONS	False	None
/api/adj/down_employee_adj/<int:year_id>/<int:employee_id>	api_adj.down_employee_adj	GET, HEAD, OPTIONS	False	None
/api/adj/list_adj/<int:spi_file_id>/<int:office_id>/<string:position_type>	api_adj.list_adj	GET, HEAD, OPTIONS	False	None
/api/adj/static/<path:filename>	api_adj.static	GET, HEAD, OPTIONS	False	None
/api/adj/year_employee_count/<int:adj_year_id>	api_adj.year_employee_count	GET, HEAD, OPTIONS	False	None
/api/analysis/<string:office>/<int:spi_file_id>/<string:data_type>/<string:manufactures>	api_analysis.adj_manufactures	GET, HEAD, OPTIONS	False	None
/api/analysis/static/<path:filename>	api_analysis.static	GET, HEAD, OPTIONS	False	None
/api/config/cost/info/<int:_id>	api_config.cost_info	GET, HEAD, OPTIONS, POST	False	None
/api/config/cost/list	api_config.cost_list	GET, HEAD, OPTIONS, POST	False	None
/api/config/delete/<string:_type>/<int:_id>	api_config.delete	DELETE, OPTIONS	False	None
/api/config/edit_role/<int:_id>	api_config.edit_role	OPTIONS, PUT	False	None
/api/config/edit_role_api/<int:_id>	api_config.edit_role_api	OPTIONS, PUT	False	None
/api/config/edit_role_power/<int:_id>	api_config.edit_role_power	OPTIONS, PUT	False	None
/api/config/office_set/all_target	api_config.all_target	GET, HEAD, OPTIONS	False	None
/api/config/office_set/info/<int:_id>	api_config.office_set_info	GET, HEAD, OPTIONS	False	None
/api/config/office_set/list	api_config.office_set_list	GET, HEAD, OPTIONS, POST	False	None
/api/config/put/office_set_info/<string:_type>/<int:_id>	api_config.put_office_set_info	OPTIONS, PUT	False	None
/api/config/put_target/<int:target_id>/<int:_id>	api_config.put_target	OPTIONS, PUT	False	None
/api/config/receive_email	api_config.receive_email	GET, HEAD, OPTIONS, POST	False	None
/api/config/role	api_config.role	GET, HEAD, OPTIONS, POST	False	None
/api/config/role_api	api_config.role_api	GET, HEAD, OPTIONS	False	None
/api/config/role_power/<int:role_id>	api_config.role_power	GET, HEAD, OPTIONS	False	None
/api/config/send_email	api_config.send_email	GET, HEAD, OPTIONS, POST	False	None
/api/config/share/download/<int:_id>	api_config.share_download	GET, HEAD, OPTIONS	False	None
/api/config/share/info/<int:_id>	api_config.share_info	GET, HEAD, OPTIONS, POST	False	None
/api/config/share/list	api_config.share_list	GET, HEAD, OPTIONS, POST	False	None
/api/config/spi_file/list	api_config.spi_file_list	GET, HEAD, OPTIONS, POST	False	None
/api/config/static/<path:filename>	api_config.static	GET, HEAD, OPTIONS	False	None
/api/config/target_info/<int:target_id>	api_config.target_info	GET, HEAD, OPTIONS	False	None
/api/config/target_list	api_config.target_list	GET, HEAD, OPTIONS, POST	False	None
/api/record/record_list/<int:employee_id>	api_record.record_sales	GET, HEAD, OPTIONS	False	None
/api/record/static/<path:filename>	api_record.static	GET, HEAD, OPTIONS	False	None
/api/share_adj/cost/<int:spi_file_id>/<int:user_id>	api_share_adj.cost	GET, HEAD, OPTIONS	False	None
/api/share_adj/download_share_adj/<int:spi_file_id>/<int:office_id>/<string:position_type>	api_share_adj.download_share_adj	GET, HEAD, OPTIONS	False	None
/api/share_adj/share/<int:spi_file_id>/<int:user_id>	api_share_adj.share	GET, HEAD, OPTIONS	False	None
/api/share_adj/share_adj/<int:spi_file_id>/<int:office_id>/<string:position_type>	api_share_adj.share_adj	GET, HEAD, OPTIONS	False	None
/api/share_adj/static/<path:filename>	api_share_adj.static	GET, HEAD, OPTIONS	False	None
/api/share_spi/download/<int:spi_file_id>	api_share_spi.download_share_adj	GET, HEAD, OPTIONS	False	None
/api/share_spi/static/<path:filename>	api_share_spi.static	GET, HEAD, OPTIONS	False	None
/api/spi/down/adj/<int:spi_file_id>	api_spi.down_adj	GET, HEAD, OPTIONS	False	None
/api/spi/forecast/<int:user_id>	api_spi.forecast	GET, HEAD, OPTIONS	False	None
/api/spi/ons/<int:user_id>	api_spi.ons	GET, HEAD, OPTIONS	False	None
/api/spi/shortage_list/<int:user_id>	api_spi.shortage_list	GET, HEAD, OPTIONS	False	None
/api/spi/spi/<int:spi_file_id>/<int:office_id>	api_spi.spi	GET, HEAD, OPTIONS	False	None
/api/spi/static/<path:filename>	api_spi.static	GET, HEAD, OPTIONS	False	None
/api/summary/catalog	api_summary.catalog	GET, HEAD, OPTIONS	False	None
/api/summary/static/<path:filename>	api_summary.static	GET, HEAD, OPTIONS	False	None
/api/users/del_user/<int:id_>	api_user.del_user	DELETE, GET, HEAD, OPTIONS	False	None
/api/users/office_user/<int:office_id>/<string:position_type>	api_user.office_user	GET, HEAD, OPTIONS	False	None
/api/users/static/<path:filename>	api_user.static	GET, HEAD, OPTIONS	False	None
/api/users/user_list	api_user.user_list	GET, HEAD, OPTIONS	False	None
/config/	config.index	GET, HEAD, OPTIONS	False	None
/config/cost/create/	config.cost_create	GET, HEAD, OPTIONS, POST	False	None
/config/cost/info/<int:_id>	config.cost_info	GET, HEAD, OPTIONS, POST	False	None
/config/cost/list	config.cost_list	GET, HEAD, OPTIONS, POST	False	None
/config/create_role_api	config.create_role_api	GET, HEAD, OPTIONS, POST	False	None
/config/office_set/create	config.office_set_create	GET, HEAD, OPTIONS, POST	False	None
/config/office_set/info/<int:_id>	config.office_set_info	GET, HEAD, OPTIONS	False	None
/config/office_set/list	config.office_set_list	GET, HEAD, OPTIONS, POST	False	None
/config/receive_email	config.receive_email	GET, HEAD, OPTIONS, POST	False	None
/config/receive_email/add	config.receive_email_add	GET, HEAD, OPTIONS, POST	False	None
/config/receive_email_del/<string:email>	config.receive_email_del	GET, HEAD, OPTIONS	False	None
/config/role	config.role	GET, HEAD, OPTIONS	False	None
/config/role_api	config.role_api	GET, HEAD, OPTIONS	False	None
/config/role_power/<int:role_id>	config.role_power	GET, HEAD, OPTIONS	False	None
/config/send_email	config.send_email	GET, HEAD, OPTIONS, POST	False	None
/config/send_email/add	config.send_email_add	GET, HEAD, OPTIONS, POST	False	None
/config/send_email_del/<string:abbreviation_name>	config.send_email_del	GET, HEAD, OPTIONS	False	None
/config/share/create/	config.share_create	GET, HEAD, OPTIONS, POST	False	None
/config/share/info/<int:_id>	config.share_info	GET, HEAD, OPTIONS, POST	False	None
/config/share/list	config.share_list	GET, HEAD, OPTIONS, POST	False	None
/config/spi_file/create/	config.spi_file_create	GET, HEAD, OPTIONS, POST	False	None
/config/spi_file/edit/<int:_id>	config.spi_file_edit	GET, HEAD, OPTIONS, POST	False	None
/config/spi_file/list	config.spi_file_list	GET, HEAD, OPTIONS, POST	False	None
/config/static/<path:filename>	config.static	GET, HEAD, OPTIONS	False	None
/config/target_create	config.target_create	GET, HEAD, OPTIONS, POST	False	None
/config/target_info/<int:target_id>	config.target_info	GET, HEAD, OPTIONS	False	None
/config/target_list	config.target_list	GET, HEAD, OPTIONS, POST	False	None
/login_phone	public.login_phone	GET, HEAD, OPTIONS, POST	False	None
/logout	public.logout	GET, HEAD, OPTIONS	False	None
/record/	record.index	GET, HEAD, OPTIONS	False	None
/record/static/<path:filename>	record.static	GET, HEAD, OPTIONS	False	None
/register	public.register	GET, HEAD, OPTIONS, POST	False	None
/share_adj/	share_adj.index	GET, HEAD, OPTIONS	False	None
/share_adj/cost_download/<int:spi_file_id>/<int:user_id>	share_adj.cost_download	GET, HEAD, OPTIONS	False	None
/share_adj/share_adj/<int:spi_file_id>	share_adj.share_adj	GET, HEAD, OPTIONS	False	None
/share_adj/share_cost/<int:spi_file_id>/<int:user_id>	share_adj.share_cost	GET, HEAD, OPTIONS	False	None
/share_adj/share_download/<int:spi_file_id>/<int:user_id>	share_adj.share_download	GET, HEAD, OPTIONS	False	None
/share_adj/static/<path:filename>	share_adj.static	GET, HEAD, OPTIONS	False	None
/share_spi/	share_spi.index	GET, HEAD, OPTIONS	False	None
/share_spi/<int:spi_file_id>/<string:key>/<string:order>/<int:all_info>	share_spi.spi	GET, HEAD, OPTIONS	False	None
/share_spi/static/<path:filename>	share_spi.static	GET, HEAD, OPTIONS	False	None
/spi/index/<int:spi_file_id>	spi.index	GET, HEAD, OPTIONS	False	None
/spi/manage	spi.manage	GET, HEAD, OPTIONS	False	None
/spi/office_performance/<int:spi_file_id>	spi.office_performance	GET, HEAD, OPTIONS	False	None
/spi/sales_list/<int:spi_file_id>	spi.sales_list	GET, HEAD, OPTIONS	False	None
/spi/service_list/<int:spi_file_id>	spi.service_list	GET, HEAD, OPTIONS	False	None
/spi/spi/<int:spi_file_id>	spi.spi	GET, HEAD, OPTIONS	False	None
/spi/spi_file/list	spi.spi_file_list	GET, HEAD, OPTIONS	False	None
/spi/static/<path:filename>	spi.static	GET, HEAD, OPTIONS	False	None
/static/<path:filename>	static	GET, HEAD, OPTIONS	False	None
/static/<path:filename>	public.static	GET, HEAD, OPTIONS	False	None
/static/bootstrap/<path:filename>	bootstrap.static	GET, HEAD, OPTIONS	False	None
/summary/<int:spi_file_id>	summary.index	GET, HEAD, OPTIONS	False	None
/summary/employee/<int:spi_file_id>/<int:user_id>	summary.employee	GET, HEAD, OPTIONS	False	None
/summary/static/<path:filename>	summary.static	GET, HEAD, OPTIONS	False	None
/test	public.test	GET, HEAD, OPTIONS	False	None
/users/	user.members	GET, HEAD, OPTIONS	False	None
/users/change_password/<int:id_>	user.change_password	GET, HEAD, OPTIONS, POST	False	None
/users/edit/<int:id_>	user.edit	GET, HEAD, OPTIONS, POST	False	None
/users/static/<path:filename>	user.static	GET, HEAD, OPTIONS	False	None
/users/user_add	user.user_add	GET, HEAD, OPTIONS, POST	False	None
/users/user_list	user.user_list	GET, HEAD, OPTIONS, POST	False	None

Profiler not active

The profiler is not activated, activate it to use it