Example #1
0
# this script it's a small Hell. Live is hard...
import inspect
import os
import sys

currentdir = os.path.dirname(
    os.path.abspath(inspect.getfile(inspect.currentframe())))
sys.path.insert(0, os.path.dirname(os.path.dirname(currentdir)))
from _common.api.auth import safeGETint
from _common.api import headers
from _common.api import auth
from _common.api import db

headers.jsonAPI()

sync0 = safeGETint('sync0')
sync1 = safeGETint('sync1')
sync2 = safeGETint('sync2')
sync3 = safeGETint('sync3')
if sync0 == 1:
    sync0 = 0
else:
    sync0 = -1

if sync1 == 1:
    sync1 = 1
else:
    sync1 = -1

if sync2 == 1:
    sync2 = 2
sys.path.insert(0, os.path.dirname(os.path.dirname(currentdir)))
from _common.api import auth
from _common.api import headers
from _common.api import db
from _common.api import utils
from _common.api import translation
from mobile_service.apiv1._mobile import sql_request_ignore_error, getTotalIdsString, sql_request
from _common.api._settings import mydb

headers.jsonAPI()
if (auth._POST is None):
    headers.errorResponse("Bad request")
out = ''
your = ''
tasks = ''
duplicate = (auth.safeGETint('duplicate') == 1)
if ('out' in auth._POST) and not (auth._POST['out'] is None):
    out = utils.clearStringHard(auth._POST['out'])
if ('your' in auth._POST) and not (auth._POST['your'] is None):
    your = utils.clearStringHard(auth._POST['your'])
if ('tasks' in auth._POST) and not (auth._POST['tasks'] is None):
    tasks = utils.clearGlobalIds(auth._POST['tasks'])

out_arr = []
your_arr = []
tasks_arr = []
tasks = getTotalIdsString(user_id=auth.user_id,
                          devid=auth.user_some_state,
                          cross=tasks,
                          extendType=0)['info']['ids']
if len(tasks) < 1:
Example #3
0
import sys
import time

currentdir = os.path.dirname(os.path.abspath(
        inspect.getfile(inspect.currentframe())))
sys.path.insert(0, os.path.dirname(os.path.dirname(currentdir)))
from _common.api.auth import safeGETint
from _common.api import headers
from _common.api import db
from _common.api import auth
from _common.api import date_utils
from _common.api._settings import mydb

headers.jsonAPI()

devid = safeGETint('devid')
timezone_offset = safeGETint('timezone')

if devid < 1:
    devid = 0

sql_filter = db.buildSqlPermissionfilter(auth.user_id, devid, True)
timestamp_int = int(time.time() * 1000)
time_endinterval = timestamp_int + 300 * 24 * 60 * 60 * 1000
sql = 'select * from tasks t where (t.type=0 or t.type=1) and t.state>=20 and t.start_time<' + str(
        time_endinterval) + ' and ' + sql_filter + ' order by t.type, t.start_time'
db.sql_request(sql)
rows = mydb.fetchall()
json_result = []
toastMessage = None
if (rows is None) or len(rows) < 1:
# this script it's a small Hell. Live is hard...
import inspect
import os
import sys

currentdir = os.path.dirname(
    os.path.abspath(inspect.getfile(inspect.currentframe())))
sys.path.insert(0, os.path.dirname(os.path.dirname(currentdir)))
from _common.api.auth import safeGETint
from _common.api import headers
from _common.api import db
from _common.api import auth

headers.jsonAPI()

filter0 = safeGETint('filter0') == 1
filter1 = safeGETint('filter1') == 1
filter2 = safeGETint('filter2') == 1
filter3 = safeGETint('filter3') == 1
filterl = safeGETint('filterl') == 1
selected = safeGETint('selected')

# if filter0 and filter1 and filter2 and filter3 and filterl:
#    filterl = False
nodes = {}
edges = {}
own = db.getUserOwnDevices(user_id=auth.user_id)
our_device_selected = False
for value in own['all']:
    if selected == value['id']:
        our_device_selected = True