function transfer_message_archive_chat()
{
$db = DBManagerFactory::getInstance();
$date_record = date('Y-m-d H:i:s', strtotime('- 1 days'));
$sql_find_mess = "SELECT id AS mess_id, cm.date_time, cm.message, cm.session_id, cm.sender_id\n FROM chat_messages AS cm\n WHERE deleted = 0\n AND date_time < '{$date_record}'\n ";
$query_find_mess = $db->query($sql_find_mess);
while ($row_find_mess = $db->fetchByAssoc($query_find_mess)) {
$chat_archives = new Chat_Archives();
$chat_archives->date_time = $row_find_mess['date_time'];
$chat_archives->message = $row_find_mess['message'];
$chat_archives->session_id = $row_find_mess['session_id'];
$chat_archives->sender_id = $row_find_mess['sender_id'];
$chat_archives->save();
$mess_id = $row_find_mess['mess_id'];
$sql_delete_mess = "DELETE FROM chat_messages\n WHERE id = '{$mess_id}'\n ";
$query_delete_mess = $db->query($sql_delete_mess);
}
}
global $current_user;
$db = DBManagerFactory::getInstance();
$friend_id = $_REQUEST['user_clear'];
$my_user_id = $current_user->id;
$sql_check = "SELECT cs.id AS session_id\n FROM chat_session AS cs\n WHERE deleted = 0\n AND (user_1_id = '{$friend_id}' OR user_1_id = '{$my_user_id}')\n AND (user_2_id = '{$my_user_id}' OR user_2_id = '{$friend_id}')\n ";
$query_check = $db->query($sql_check);
$session_id = array();
while ($row_check = $db->fetchByAssoc($query_check)) {
$session_id[] = $row_check['session_id'];
}
foreach ($session_id as $session) {
$sql_session = "SELECT id AS mess_id, cmess.message, cmess.date_time, cmess.sender_id\n FROM chat_messages AS cmess\n WHERE deleted = 0\n AND session_id = '{$session}'\n ";
$query_session = $db->query($sql_session);
while ($row_session = $db->fetchByAssoc($query_session)) {
$chat_archives = new Chat_Archives();
$chat_archives->date_time = $row_session['date_time'];
$chat_archives->message = $row_session['message'];
$chat_archives->session_id = $session;
$chat_archives->sender_id = $row_session['sender_id'];
$chat_archives->save();
$mess_id = $row_session['mess_id'];
$sql_delete_mess = "DELETE FROM chat_messages\n WHERE id = '{$mess_id}'\n ";
$query_delete_mess = $db->query($sql_delete_mess);
}
}
////$date_record = date('Y-m-d H:i:s', strtotime('- 1 days' ));
//
//$sql_find_mess = "SELECT id AS mess_id, cm.date_time, cm.message, cm.session_id, cm.sender_id
// FROM chat_messages AS cm
// WHERE deleted = 0
