123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086 |
- <?php
- global $_qbf_er;
- $_qbf_er = error_reporting(E_ALL | E_STRICT);
- define('QBF_LEVEL_REMOVE', 0);
- define('QBF_LEVEL_DISPLAY', 1);
- define('QBF_LEVEL_OPTIONAL', 2);
- define('QBF_LEVEL_REQUIRED', 3);
- define('QBF_PATH_MAIN', 'qbf');
- define('QBF_PATH_AC', 'qbf/ac');
- define('QBF_PATH_SETTINGS', 'admin/settings/qbf');
- define('QBF_PERM_QUERY', 'use QBF search functions');
- define('QBF_PERM_ADMIN', 'administer QBF');
- define('QBF_TABLE_NAME', 'qbf_queries');
- define('QBF_VAR_NOTIFY_DELETE', 'qbf_notify_delete');
- define('QBF_VAR_PROFILE_CATEGORY', 'qbf_profile_category');
- define('QBF_DEF_NOTIFY_DELETE', FALSE);
- define('QBF_DEF_PROFILE_CATEGORY', 'Saved queries');
- class Qbf_Query
- {
- public $qid;
- public $uid;
- public $name;
- public $type;
- public $query;
- public $created;
- public $updated;
-
- public function __construct($type, $name, $ar_values)
- {
- global $user;
- $this->qid = 0;
- $this->uid = $user->uid;
- $this->type = $type;
- $this->name = $name;
- $this->query = serialize($ar_values);
- $this->created = $this->updated = time();
- }
-
- public function save()
- {
-
- if (!empty($this->name))
- {
- $sq = "DELETE FROM {%s} WHERE name = '%s' AND uid = '%d' ";
- db_query($sq, QBF_TABLE_NAME, $this->name, $this->uid);
-
- }
- $ret = drupal_write_record(QBF_TABLE_NAME, $this);
- if ($ret)
- {
- $ret = $this->qid;
- }
- return $ret;
- }
- }
- function _qbf_extract_query($element_id, $form, $form_values)
- {
-
- if (!empty($element_id) && array_key_exists('#qbf', $form) && array_key_exists('#level', $form['#qbf'])
- && $form['#qbf']['#level'] >= QBF_LEVEL_OPTIONAL)
- {
- $ret = array($element_id => $form_values[$element_id]);
- }
- else
- {
- $ret = array();
- }
-
- foreach (element_children($form) as $child_name)
- {
- $ret += _qbf_extract_query($child_name, $form[$child_name], $form_values);
- }
- return $ret;
- }
- function _qbf_query_delete($query)
- {
- global $user;
- if (is_int($query))
- {
- $query = qbf_query_load($query);
- }
- if ($query)
- {
- $qid = $query->qid;
- $sq = 'DELETE FROM %s WHERE qid = %d ';
- $q = db_query($sq, QBF_TABLE_NAME, $qid);
- $message = t('Query @id "@name" has been deleted.', array
- (
- '@id' => $qid,
- '@name' => $query->name,
- ));
- drupal_set_message($message, 'status');
- $link = l($qid, QBF_PATH_MAIN .'/'. $qid .'/delete');
- $notify = variable_get(QBF_VAR_NOTIFY_DELETE, QBF_DEF_NOTIFY_DELETE);
- watchdog('qbf', $message, NULL, WATCHDOG_NOTICE, $link);
-
-
- if ($notify )
- {
- $owner = user_load(array('uid' => $query->uid));
- $language = user_preferred_language($account);
- $params = array
- (
- 'query' => $query,
- 'owner' => $owner,
- 'deletor' => $user,
- 'language' => $language,
- );
- $ret = drupal_mail('qbf', __FUNCTION__, $user->mail, $language, $params, $user->mail);
- drupal_set_message(t('User !link has been informed', array
- (
- '!link' => l($account->name, 'user/'. $query->uid),
- )));
-
- }
- }
- else {
- $message = t('Failed attempt to delete query @qid. Administrator has been alerted.', array
- (
- '@qid' => $qid,
- ));
- drupal_set_message($message, 'error');
- watchdog('qbf', $message, NULL, WATCHDOG_ERROR, $link);
- }
- drupal_goto();
- }
- function _qbf_transform_element($key, $element, $form_state, $query)
- {
-
-
- static $ar_default_type_transformations = array
- (
- 'button' => NULL,
- 'file' => NULL,
- 'image_button' => NULL,
- 'markup' => NULL,
- 'password' => NULL,
- 'radio' => NULL,
- 'submit' => NULL,
- 'textarea' => 'textfield',
-
-
-
-
-
-
-
-
-
-
-
-
-
- );
-
- static $ar_default_property_transformations = array
- (
-
- '#action' => NULL,
- '#after_build' => NULL,
-
- '#button_type' => NULL,
- '#built' => NULL,
- '#description' => NULL,
- '#method' => NULL,
- '#parents' => NULL,
- '#redirect' => NULL,
- '#ref' => NULL,
- '#required' => NULL,
- '#rows' => NULL,
- '#submit' => NULL,
- '#tree' => NULL,
- '#validate' => NULL,
- );
-
- static $ar_killer_properties = array
- (
- '#disabled' => TRUE,
- );
-
- $source_type = $element['#type'];
-
- $dest_type = array_key_exists($source_type, $ar_default_type_transformations)
- ? $ar_default_type_transformations[$source_type]
- : $source_type;
-
- if (isset($element['#qbf']['#type']))
- {
- $dest_type = $element['#qbf']['#type'];
- }
- if (is_null($dest_type))
- {
- $ret = NULL;
- }
- else
- {
- $ret = $element;
- $ret['#type'] = $dest_type;
- if (!array_key_exists('#qbf', $element) || $element['#qbf']['#level'] == QBF_LEVEL_REMOVE)
- {
- $ret = NULL;
- }
- else
- {
- foreach (element_properties($element) as $property_name)
- {
-
- if (array_key_exists($property_name, $ar_killer_properties)
- && ($element[$property_name] = $ar_killer_properties[$property_name]))
- {
- $ret = NULL;
- break;
- }
-
- if (array_key_exists($property_name, $ar_default_property_transformations))
- {
- $ret[$property_name] = $ar_default_property_transformations[$property_name];
- }
- else
- {
- $ret[$property_name] = $element[$property_name];
- }
-
- if ($property_name == '#qbf')
- {
- foreach ($element[$property_name] as $override_name => $override_value)
- {
- $ret[$override_name] = $override_value;
- }
- }
- }
- if (isset($form_state['values'][$key]))
- {
- $ret['#default_value'] = $form_state['values'][$key];
- }
- elseif (isset($query->query[$key]))
- {
- $ret['#default_value'] = $query->query[$key];
- }
-
- foreach (element_children($element) as $child_name)
- {
- $child = _qbf_transform_element($child_name, $element[$child_name], $form_state, $query);
- if (is_null($child))
- {
- unset($ret[$child_name]);
- }
- else
- {
- $ret[$child_name] = $child;
- }
- }
- }
- }
-
- return $ret;
- }
- function qbf_admin_settings()
- {
- $form = array();
- $form[QBF_VAR_NOTIFY_DELETE] = array
- (
- '#type' => 'checkbox',
- '#default_value' => variable_get(QBF_VAR_NOTIFY_DELETE, QBF_DEF_NOTIFY_DELETE),
- '#title' => t('Notify users when one of their saved searches has been deleted'),
- );
- return system_settings_form($form);
- }
- function qbf_form_save_submit($form, &$form_state)
- {
- $qid = _qbf_save($form_state['values']['form_id'], $form_state);
- drupal_set_message(t('Your query was saved as "@name".',
- array('@name' => $form_state['values']['qbf_save_name'])));
- global $user;
- $form_state['redirect'] = "user/$user->uid/edit/qbf";
- return $qid;
- }
- function qbf_forms($qbf_form_id, $args)
- {
- $hook_name = 'qbf_register';
-
-
- foreach (module_implements($hook_name) as $module)
- {
- $arImplementations = module_invoke($module, $hook_name);
-
- foreach ($arImplementations as $query_type => $query_info)
- {
- $forms['qbf_' . $query_info['form']] = array
- (
- 'callback' => 'qbf_form',
- 'callback arguments' => array($query_info, $qbf_form_id),
- );
- }
- }
- return $forms;
- }
- function qbf_get_queries_by_user($uid = NULL)
- {
- if (is_null($uid))
- {
- global $user;
- $uid = $user->uid;
- }
- $sq = 'SELECT qq.qid, qq.uid, qq.name, qq.query, qq.updated '
- . 'FROM {%s} qq '
- . 'WHERE qq.uid = %d '
- . 'ORDER BY qq.name ';
-
-
- $q = db_query($sq, QBF_TABLE_NAME, $uid);
- $ret = array();
- while ($o = db_fetch_object($q))
- {
- $ret[$o->qid] = $o;
- }
- return $ret;
- }
- function qbf_menu()
- {
- $items = array();
- $items[QBF_PATH_MAIN . '/demo'] = array
- (
- 'title' => 'QBF Demo',
- 'access arguments' => array(QBF_PERM_QUERY),
- 'page callback' => 'qbf_show',
- 'type' => MENU_NORMAL_ITEM,
- );
- $items[QBF_PATH_SETTINGS] = array
- (
- 'title' => 'Query-By-Form',
- 'access arguments' => array(QBF_PERM_ADMIN),
- 'page callback' => 'drupal_get_form',
- 'page arguments' => array('qbf_admin_settings'),
- 'type' => MENU_NORMAL_ITEM,
- );
- $items[QBF_PATH_MAIN . '/%qbf_query'] = array
- (
- 'type' => MENU_CALLBACK,
- 'access arguments' => array(QBF_PERM_QUERY),
- 'page callback' => 'qbf_query_form',
- 'page arguments' => array(1),
- );
- $items[QBF_PATH_MAIN . '/%qbf_query/delete'] = array
- (
- 'type' => MENU_CALLBACK,
- 'access arguments' => array(QBF_PERM_QUERY),
- 'page callback' => '_qbf_query_delete',
- 'page arguments' => array(1),
- );
- return $items;
- }
- function qbf_mail($key, &$message, $params)
- {
-
- $deletor_tokens = user_mail_tokens($params['deletor'], $params['language']->language);
- $tokens = array_merge($deletor_tokens, array
- (
- '!qname' => $params['query']->name,
- '!qid' => $params['query']->qid,
- ));
- $message['subject'] = t('Effacement d\'une recherche !site enregistrée', $tokens);
- $message['body'] = t("!date\n\nVotre recherche !qid: !qname\nsur le site !site vient d'être effacée par !username.", $tokens);
- }
- function qbf_perm()
- {
- $ret = array
- (
- QBF_PERM_ADMIN,
- QBF_PERM_QUERY,
- );
- return $ret;
- }
- function qbf_query_load($us_qid)
- {
- static $query = NULL;
-
- if (user_is_anonymous())
- {
- return FALSE;
- }
-
- $qid = (is_numeric($us_qid) && ($us_qid > 0))
- ? $us_qid
- : 0;
- if (is_null($query))
- {
- $sq = 'SELECT qq.qid, qq.uid, qq.type, qq.name, qq.query '
- . 'FROM {%s} qq '
- . 'WHERE qq.qid = %d ';
-
- $q = db_query($sq, QBF_TABLE_NAME, $qid);
- $query = db_fetch_object($q);
-
- if ($query !== NULL)
- {
- $query->query = unserialize($query->query);
-
- }
- }
- global $user;
- $ret = (isset($query) && (($query->uid == $user->uid) || user_access(QBF_PERM_ADMIN)))
- ? $query
- : FALSE;
- return $ret;
- }
- function qbf_query_mapper($ar_query_map = array(), $ar_defaults = array())
- {
- $ret = array();
- foreach ($ar_query_map as $name => $value)
- {
-
- if (!is_array($value))
- {
- $value = array();
- }
- $item = $value;
- foreach ($ar_defaults as $default_key => $default_value)
- {
- if (!array_key_exists($default_key, $item))
- {
- $item[$default_key] = is_null($default_value)
- ? $name
- : $default_value;
- }
-
- }
- $ret[$name] = $item;
- }
- return $ret;
- }
- error_reporting($_qbf_er);
- function qbf___________________________________________________(){}
- function qbf_transform_form($form_state, $form_id)
- {
-
- $form = drupal_retrieve_form($form_id, $form_state, NULL, $form_state);
- $node = new stdClass();
- $form = $form_id($node, $form_state);
- $new_form_id = "qbf_$form_id";
-
- $elements = array();
- $new_form = array();
- $new_form['#qbf_source_form_id'] = $form_id;
- if (in_array('#qbf', element_properties($form)))
- {
- $new_form += $form['#qbf'];
- }
- foreach (element_children($form) as $key)
- {
-
- $new_element = _qbf_transform_element($key, $form[$key]);
- if (!is_null($new_element))
- {
- $new_form[$key] = $new_element;
- }
- }
- $new_form['#id'] = $new_form_id;
-
-
-
-
- $new_form['#after_build'][] = 'qbf_after_build';
- $new_form['#submit'] = array('qbf_submit');
-
- return $new_form;
- }
- function qbf_after_build($form, $form_values) {
- if (empty($form['#post'])) {
- return $form;
- }
-
- $ar_query = _qbf_extract_query($form, $form_values);
-
- if (isset($form['#callback']) && function_exists($function = $form['#callback'])) {
- $results = $function($ar_query);
- }
- else {
- drupal_set_message(t('QBF: incorrect callback function for search'), 'error');
- }
- $form['qbf_query_results'] = array
- (
- '#type' => 'markup',
- '#value' => $results,
- '#weight' => 10,
- );
- return $form;
- }
- function qbf_import_values($element, $form_values) {
- foreach (element_children($element) as $child_name) {
- if (!empty($form_values[$child_name])) {
- $element[$child_name]['#qbf']['#default_value'] = $form_values[$child_name];
- }
- $element[$child_name] = qbf_import_values($element[$child_name], $form_values);
- }
- return $element;
- }
- function _qbf_save($form_id, $form_state)
- {
- if (user_is_anonymous())
- {
- $warning = t('Attempt by anonymous user to save a QBF query. Should not happen.');
- drupal_set_message($warning, 'error');
- watchdog('qbf', $warning, NULL, WATCHDOG_WARNING);
- $ret = 0;
- }
- else
- {
-
- $form = drupal_retrieve_form($form_id, $form_state);
-
- drupal_prepare_form($form_id, $form, $form_state);
-
- $name = $form_state['values']['qbf_save_name'];
- $type = $form_state['values']['qbf_save_type'];
-
- $form_values = _qbf_extract_query(NULL, $form, $form_state['values']);
-
- $ar_values = array();
- foreach ($form_values as $key => $value)
- {
- if (empty($value))
- {
- continue;
- }
- $ar_values[$key] = $value;
- }
- $query = new Qbf_Query($type, $name, $ar_values);
- $ret = $query->save();
- }
- return $ret;
- }
- function qbf_form(&$form_state, $query_info, $qbf_form_id, $query = NULL)
- {
- $form_id = $query_info['form'];
-
-
-
- $node = new stdClass();
- $form = $form_id($node, $form_state);
- $qbf_form = array();
- $qbf_form['#qbf_source_form_id'] = $form_id;
-
- if (in_array('#qbf', element_properties($form)))
- {
- $qbf_form += $form['#qbf'];
- }
- foreach (element_children($form) as $key)
- {
- $new_element = _qbf_transform_element($key, $form[$key], $form_state, $query);
- if (!is_null($new_element))
- {
- $qbf_form[$key] = $new_element;
- }
- }
- $qbf_form['#id'] = $qbf_form_id;
-
- $qbf_form['qbf'] = array
- (
- '#type' => 'fieldset',
- '#title' => t('Query'),
- );
- if (isset($form_state['values']) && !empty($form_state['values']))
- {
-
- if (isset($form_state['qbf_results']))
- {
- $qbf_form['qbf']['qbf_results'] = array
- (
- '#type' => 'markup',
- '#prefix' => '<p>',
- '#value' => $form_state['qbf_results'],
- '#suffix' => '</p>',
- );
- }
- }
- $qbf_form['qbf']['qbf_save_type'] = array
- (
- '#type' => 'hidden',
- '#value' => $query_info['form'],
- );
- $qbf_form['qbf']['qbf_query'] = array
- (
- '#type' => 'hidden',
- '#value' => $query_info['callback'],
- );
- $qbf_form['qbf']['qbf_save_name'] = array
- (
- '#title' => t('Name of query in your save list'),
- '#type' => 'textfield',
- '#required' => TRUE,
- '#default_value' => empty($query->name)
- ? substr($form_id, 0, -5) . ' ' . format_date(time(), 'large')
- : $query->name,
- );
- $qbf_form['qbf']['qbf_save'] = array
- (
- '#submit' => array('qbf_form_save_submit'),
- '#validate' => array('qbf_form_save_validate'),
- '#type' => 'submit',
- '#value' => t('Save query'),
- '#weight' => 5,
- );
- $qbf_form['qbf']['qbf_perform'] = array
- (
- '#submit' => array('qbf_form_perform_submit'),
-
- '#type' => 'submit',
- '#value' => t('Perform query'),
- '#weight' => 4,
- );
- return $qbf_form;
- }
- function qbf_form_perform_submit($form, &$form_state)
- {
-
-
-
- $callback = $form_state['values']['qbf_query'];
- if (function_exists(($callback)))
- {
- $ar_query = _qbf_extract_query(NULL, $form, $form_state['values']);
- $form_state['qbf_results'] = $callback($ar_query);
- }
- $form_state['rebuild'] = TRUE;
- }
- function qbf_query_form($query)
- {
- $qbf_form_id = 'qbf_' . $query->type;
- $form = drupal_get_form($qbf_form_id, $query);
- return $form;
- }
- function qbf_profile_alter(&$account)
- {
-
- global $user;
-
- if ($user->uid != $account->uid && !user_access(QBF_PERM_ADMIN))
- {
- return;
- }
- $ar_queries = qbf_get_queries_by_user($account->uid);
- $count = count($ar_queries);
-
- $new_query_link = l(t('Create new query'), JOB_PATH_MAIN);
- $none_message = ($account->uid == $user->uid)
- ? t('None yet. !newQuery', array('!newQuery' => $new_query_link))
- : t('None yet.');
- $saved = ($count > 0)
- ? format_plural($count, 'One saved query. ', '@count saved queries. ')
- . l(t('View/edit'), "user/$account->uid/edit/qbf")
- : $none_message;
-
- $cat_name = variable_get(QBF_VAR_PROFILE_CATEGORY, QBF_DEF_PROFILE_CATEGORY);
-
- if (!array_key_exists($cat_name, $account->content))
- {
- $account->content[$cat_name] = array();
- }
-
-
- }
|