Subversion Repositories SmartDukaan

Rev

Rev 1899 | Rev 2020 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1899 Rev 1996
Line 305... Line 305...
305
    return Affiliate.get_by(name = name)
305
    return Affiliate.get_by(name = name)
306
 
306
 
307
def get_affiliates_by_master_affiliate(master_affiliate_id):
307
def get_affiliates_by_master_affiliate(master_affiliate_id):
308
    return MasterAffiliate.get_by(id =  master_affiliate_id).affiliates
308
    return MasterAffiliate.get_by(id =  master_affiliate_id).affiliates
309
 
309
 
310
def create_tracker(affiliate_id, added_on):
-
 
311
    tracker = Tracker()
-
 
312
    tracker.affiliate_id = affiliate_id
-
 
313
    tracker.added_on = to_py_date(added_on)
-
 
314
    session.commit()
-
 
315
    return tracker
-
 
316
 
-
 
317
def get_tracker_by_id(id):
310
def get_tracker_by_id(id):
318
    return Tracker.get_by(id = id)
311
    return Tracker.get_by(id = id)
319
 
312
 
320
def get_trackers_by_affiliate(affiliate_id):
-
 
321
    return Affiliate.get_by(id = affiliate_id).trackers
-
 
322
 
-
 
323
def add_track_log(tracker_id, user_id, event, url, data, added_on):
313
def add_track_log(affiliate_id, user_id, event, url, data, added_on):
324
    track_log = TrackLog()
314
    track_log = TrackLog()
325
    track_log.tracker_id = tracker_id
315
    track_log.affiliate_id = affiliate_id
326
    if user_id:
316
    if user_id:
327
        track_log.user_id = user_id
317
        track_log.user_id = user_id
328
    track_log.event = event
318
    track_log.event = event
329
    if url:
319
    if url:
330
        track_log.url = url
320
        track_log.url = url
Line 335... Line 325...
335
    return track_log.id
325
    return track_log.id
336
 
326
 
337
def get_track_log_by_id(id):
327
def get_track_log_by_id(id):
338
    return TrackLog.get_by(id = id)
328
    return TrackLog.get_by(id = id)
339
 
329
 
340
def get_track_logs_by_tracker(tracker_id):
330
def get_track_logs_by_affiliate(affiliate_id):
341
    return Tracker.get_by(id = tracker_id).tracklogs
331
    return Affiliate.get_by(id = affiliate_id).tracklogs
342
 
332
 
343
def get_track_logs_by_user(user_id):
333
def get_track_logs_by_user(user_id):
344
    return TrackLog.query.filter(TrackLog.user_id == user_id).all()
334
    return TrackLog.query.filter(TrackLog.user_id == user_id).all()
345
 
335
 
346
def get_track_logs(trackerId, userId, event, url):
336
def get_track_logs(affiliate_id, user_id, event, url):
347
    query = TrackLog.query
337
    query = TrackLog.query
348
    
338
    
349
    if trackerId:
339
    if affiliate_id:
350
        query = query.filter(TrackLog.tracker_id == trackerId)
340
        query = query.filter(TrackLog.affiliate_id == affiliate_id)
351
    if userId:
341
    if user_id:
352
        query = query.filter(TrackLog.user_id == userId)
342
        query = query.filter(TrackLog.user_id == user_id)
353
    if event:
343
    if event:
354
        query = query.filter(TrackLog.event == event)
344
        query = query.filter(TrackLog.event == event)
355
    if url:
345
    if url:
356
        query = query.filter(TrackLog.url == url)
346
        query = query.filter(TrackLog.url == url)
357
    return query.all()
347
    return query.all()