fn get_by_status_with_skus_trade(conn: &Connection, status: &str, pagination: &mut Pagination, is_pagination: &bool, offset: &Option<i32>, length: &Option<i32>)
  -> Result <(Vec<Order>, Vec<ItemOrder>, Vec<Coupon>), Error>
{
    let stmt;
    let rows;
    if *is_pagination {

        let sql = format!("SELECT * from mytable
                      ORDER BY b.order_id DESC LIMIT {} OFFSET {}",
                       length.unwrap(), length.unwrap() * (offset.unwrap() - 1));

        stmt = try!(conn.prepare(&sql));
        rows = try!(stmt.query(&[&status]));

        let count_stmt = try!(conn.prepare("SELECT COUNT(*) from mytable)"));


        let postgres_row = try!(count_stmt.query(&[&status]));
        pagination.set_pagination(postgres_row);
    } else {
            stmt = try!(conn.prepare("SELECT * from mytable'))
                  ORDER BY b.order_id DESC"));

        rows = try!(stmt.query(&[&status]));
    }
    Ok(get_info_with_skus_trade(&rows, &conn))
}