134 files changed, 31073 insertions, 30287 deletions
diff --git a/tvapi/libtv/tv/CTvBooking.cpp b/tvapi/libtv/tv/CTvBooking.cpp index e821809..1ad45db 100644 --- a/tvapi/libtv/tv/CTvBooking.cpp +++ b/tvapi/libtv/tv/CTvBooking.cpp @@ -8,147 +8,147 @@ #endif int CTvBooking::InitFromCursor(CTvDatabase::Cursor &c) { - int col; + int col; - col = c.getColumnIndex("db_id"); - this->id = c.getInt(col); + col = c.getColumnIndex("db_id"); + this->id = c.getInt(col); - col = c.getColumnIndex("db_srv_id"); - this->programId = c.getInt(col); + col = c.getColumnIndex("db_srv_id"); + this->programId = c.getInt(col); - col = c.getColumnIndex("db_evt_id"); - this->eventId = c.getInt(col); + col = c.getColumnIndex("db_evt_id"); + this->eventId = c.getInt(col); - col = c.getColumnIndex("flag"); - this->flag = c.getInt(col); + col = c.getColumnIndex("flag"); + this->flag = c.getInt(col); - col = c.getColumnIndex("status"); - this->status = c.getInt(col); + col = c.getColumnIndex("status"); + this->status = c.getInt(col); - col = c.getColumnIndex("repeat"); - this->repeat = c.getInt(col); + col = c.getColumnIndex("repeat"); + this->repeat = c.getInt(col); - col = c.getColumnIndex("start"); - this->start = (long)c.getInt(col); + col = c.getColumnIndex("start"); + this->start = (long)c.getInt(col); - col = c.getColumnIndex("duration"); - this->duration = (long)c.getInt(col) ; + col = c.getColumnIndex("duration"); + this->duration = (long)c.getInt(col) ; - col = c.getColumnIndex("srv_name"); - this->progName = c.getString(col); + col = c.getColumnIndex("srv_name"); + this->progName = c.getString(col); - col = c.getColumnIndex("evt_name"); - this->evtName = c.getString(col); + col = c.getColumnIndex("evt_name"); + this->evtName = c.getString(col); - return 0; + return 0; } int CTvBooking::selectByID(int id, CTvBooking &CtvBook) { - CTvDatabase::Cursor c; - String8 sql; - - sql = String8("select * from booking_table where booking_table.db_evt_id = ") + String8::format("%d", id); - CTvDatabase::GetTvDb()->select(sql.string(), c); - if (c.moveToFirst()) { - CtvBook.InitFromCursor(c); - } else { - c.close(); - return -1; - } - - c.close(); - return 0; + CTvDatabase::Cursor c; + String8 sql; + + sql = String8("select * from booking_table where booking_table.db_evt_id = ") + String8::format("%d", id); + CTvDatabase::GetTvDb()->select(sql.string(), c); + if (c.moveToFirst()) { + CtvBook.InitFromCursor(c); + } else { + c.close(); + return -1; + } + + c.close(); + return 0; } int CTvBooking::getBookedEventList(Vector<sp<CTvBooking> > &vBv) { - String8 cmd; + String8 cmd; - cmd = String8("select * from booking_table order by start"); + cmd = String8("select * from booking_table order by start"); - CTvDatabase::Cursor c; - int ret = CTvDatabase::GetTvDb()->select(cmd, c); + CTvDatabase::Cursor c; + int ret = CTvDatabase::GetTvDb()->select(cmd, c); - if (c.moveToFirst()) { - do { - vBv.add(new CTvBooking(c)); - } while (c.moveToNext()); + if (c.moveToFirst()) { + do { + vBv.add(new CTvBooking(c)); + } while (c.moveToNext()); - } else { - c.close(); - return -1; - } + } else { + c.close(); + return -1; + } - c.close(); - return 0; + c.close(); + return 0; } int CTvBooking::bookProgram(CTvProgram &prog, CTvEvent &evt) { - String8 cmd; - String8 progName = String8(prog.getName()); - String8 evtName = String8(evt.getName()); + String8 cmd; + String8 progName = String8(prog.getName()); + String8 evtName = String8(evt.getName()); - /*book this program*/ - cmd = String8("insert into booking_table(db_srv_id, db_evt_id, srv_name, evt_name,") - + String8("start,duration,flag,status,file_name,vid_pid,vid_fmt,aud_pids,aud_fmts,aud_languages,") - + String8("sub_pids,sub_types,sub_composition_page_ids,sub_ancillary_page_ids,sub_languages,") - + String8("ttx_pids,ttx_types,ttx_magazine_numbers,ttx_page_numbers,ttx_languages, other_pids,from_storage,repeat)") - + String8("values(") + String8::format("%d,", prog.getID()) + String8::format("%d,", evt.getEventId()) + progName.string() + String8(",") + evtName.string() - + String8::format("%d,", evt.getStartTime()) + String8::format("%d,", evt.getEndTime() - evt.getStartTime()) + String8::format("%d,", flag) - + String8::format("%d,", status) + String8(",") + String8::format("%d,", prog.getVideo()->getPID()) + String8::format("%d,", prog.getVideo()->getFormat()) - + String8::format("%d,", prog.getAudio(0)->getPID()) + String8::format("%d,", prog.getAudio(0)->getFormat()) + prog.getAudio(0)->getLang().string() - + String8(" , , , , , , , , , , , , ,)"); + /*book this program*/ + cmd = String8("insert into booking_table(db_srv_id, db_evt_id, srv_name, evt_name,") + + String8("start,duration,flag,status,file_name,vid_pid,vid_fmt,aud_pids,aud_fmts,aud_languages,") + + String8("sub_pids,sub_types,sub_composition_page_ids,sub_ancillary_page_ids,sub_languages,") + + String8("ttx_pids,ttx_types,ttx_magazine_numbers,ttx_page_numbers,ttx_languages, other_pids,from_storage,repeat)") + + String8("values(") + String8::format("%d,", prog.getID()) + String8::format("%d,", evt.getEventId()) + progName.string() + String8(",") + evtName.string() + + String8::format("%d,", evt.getStartTime()) + String8::format("%d,", evt.getEndTime() - evt.getStartTime()) + String8::format("%d,", flag) + + String8::format("%d,", status) + String8(",") + String8::format("%d,", prog.getVideo()->getPID()) + String8::format("%d,", prog.getVideo()->getFormat()) + + String8::format("%d,", prog.getAudio(0)->getPID()) + String8::format("%d,", prog.getAudio(0)->getFormat()) + prog.getAudio(0)->getLang().string() + + String8(" , , , , , , , , , , , , ,)"); - CTvDatabase::GetTvDb()->exeSql(cmd.string()); + CTvDatabase::GetTvDb()->exeSql(cmd.string()); - return 0; + return 0; } int CTvBooking::deleteBook(int evtIdFlag) { - String8 cmd; + String8 cmd; - cmd = String8("delete from booking_table where db_evt_id=") - + String8::format("%d", evtIdFlag); + cmd = String8("delete from booking_table where db_evt_id=") + + String8::format("%d", evtIdFlag); - CTvDatabase::GetTvDb()->exeSql(cmd.string()); + CTvDatabase::GetTvDb()->exeSql(cmd.string()); - return 0; + return 0; } int CTvBooking::bookEvent(int evtId, bool bBookFlag) { - String8 cmd; + String8 cmd; - cmd = String8("update evt_table set sub_flag=") + String8::format("%d", bBookFlag) - + String8(" where db_id=") + String8::format("%d", evtId); + cmd = String8("update evt_table set sub_flag=") + String8::format("%d", bBookFlag) + + String8(" where db_id=") + String8::format("%d", evtId); - CTvDatabase::GetTvDb()->exeSql(cmd.string()); + CTvDatabase::GetTvDb()->exeSql(cmd.string()); - if (true == bBookFlag) { - CTvEvent evt; - CTvEvent::selectByID(evtId, evt); + if (true == bBookFlag) { + CTvEvent evt; + CTvEvent::selectByID(evtId, evt); - CTvProgram prog; - CTvProgram::selectByID(evt.getProgramId(), prog); + CTvProgram prog; + CTvProgram::selectByID(evt.getProgramId(), prog); - bookProgram(prog, evt); - } else { - deleteBook(evtId); - } + bookProgram(prog, evt); + } else { + deleteBook(evtId); + } - return 0; + return 0; } CTvBooking::CTvBooking(CTvDatabase::Cursor &c) { - InitFromCursor(c); + InitFromCursor(c); } CTvBooking::CTvBooking() |